strtime

  1. R

    Change string date format based on contents of another column

    Hello We have a sheet that includes the date in custom date format (13/03/2018 8:15:00 AM) We are using the below code to convert the date to different format and into text (Day of the week is hidden at this time) <CODE> Dim c As Range For Each c In ws.UsedRange.Columns("C").Cells...
  2. D

    Assigning the Hour of the day to a variable

    So im creating a spin button that connects to a macro. The button would increment a cell by 1 based on the hour of the day and what day of the week it is. The code im using is: Sub OneClick() Dim strTime Dim LWeekday As Integer strTime = Time LWeekday = Weekday(vbUseSystemDayOfWeek)...
  3. Kentetsu

    Feeding a Variable to Application.Wait?

    Hi all, I'm attempting to reuse strTime as the variable for Application.Wait but I'm getting a "Type Mismatch" when it gets to that point. Any idea on how to make this work? Dim strMsg As String Dim strTime As String...
  4. J

    strtime 12 hour clock

    I am having trouble with a wintimer script. I want to change the format to a 12 hour clock, can anyone help with this. The format I am current using is. Dim strTime As String strTime = Format$(Now(), "hh:mm:ss") 'strTime = Format$(Now(), "h:mm:ss am/pm") I have tried changing...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top