Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting times
I am trying to write a function to display the time elapsed since
StartTime and Now() and have it formatted as H:mm:ss I tried this code: Format(DateDiff("s", StartTime, Now()), "H:mm:ss") but without result. Can someone please help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting times
Try this
Debug.Print Format(Now() - starttime, "H:mm:ss") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "SmilingPolitely" wrote in message . au... I am trying to write a function to display the time elapsed since StartTime and Now() and have it formatted as H:mm:ss I tried this code: Format(DateDiff("s", StartTime, Now()), "H:mm:ss") but without result. Can someone please help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Times | Excel Worksheet Functions | |||
Conditional Formatting Times | Excel Discussion (Misc queries) | |||
Conditional Formatting for times | Excel Discussion (Misc queries) | |||
Formatting Times In Excel | Excel Worksheet Functions | |||
Formatting values to be Times of day... | Excel Discussion (Misc queries) |