Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone,
How can I get the total processing time of a Sub to appear in a message box once the Sub has finished please. I have got ... Dim start As Double Start = Timer .... so far but want it to produce the processing time in the format x hours y minutes & z seconds. I know it will be something like Timer - Start but then I am at a loss. Perhaps something like ... "Processing Time " & Format(Timer - Start) / 24 / 60 / 60) = x hours y minutes & z seconds) Thanks in Advance. All the Best. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |