| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Hours Minutes Seconds Please
Hi Everyone,
I have this Bit of Code that Outputs the Total Processing Time of a Macro … Active.Offset(1, 0) = "Processing Time " & _ Format(((Timer - Start) / 24 / 60 / 60), "hh:mm:ss") … in the Format 00:09:36 which Works Great. What I would like is for it to Output with the Words Hours, Minutes and Seconds … 00 Hours 09 Minutes 36 Seconds. I have Tried Using the "&" and Text But to No Avail. Any Help will be Appreciated. Thanks in Advance. Paul *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to convert 157.25 minutes, into hours, minutes and seconds. | Excel Discussion (Misc queries) | |||
| Converting hours, minutes, seconds, to hours | Excel Worksheet Functions | |||
| Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
| Converting hours:minutes:seconds to just minutes | Excel Worksheet Functions | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
![Paul Black[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
