Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculate Duration.
Need Help..
I would like to subtract the end time(hh:mm:ss) from the start time(hh:mm:ss) to get the duration (HH:MM:SS) of how long a job took to process. Thanks. |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Hi Art
Sub test() Dim t As Date, tt As Date t = Now 'Your code tt = Now MsgBox Format((tt - t), "hh:mm:ss") End Sub -- XL2003 Regards William "Art" wrote in message ... Need Help.. I would like to subtract the end time(hh:mm:ss) from the start time(hh:mm:ss) to get the duration (HH:MM:SS) of how long a job took to process. Thanks. |
#4
|
|||
|
|||
Thank you Dodo & William
"Art" wrote: Need Help.. I would like to subtract the end time(hh:mm:ss) from the start time(hh:mm:ss) to get the duration (HH:MM:SS) of how long a job took to process. Thanks. |
#5
|
|||
|
|||
Dodo & William
I have encountered this error. Could you tell me what I'm missing. c3 = 22:47:00 c2 = 00:01:00 answer: ############## I only get the above answer when using the midnight time. "Art" wrote: Thank you Dodo & William "Art" wrote: Need Help.. I would like to subtract the end time(hh:mm:ss) from the start time(hh:mm:ss) to get the duration (HH:MM:SS) of how long a job took to process. Thanks. |
#6
|
|||
|
|||
Did you use:
=c2-c3 If you did, then when excel sees negative times (or dates), it shows them as ####'s. You can avoid this by using the 1904 base date system. Tools|Options|calculation tab is where you'd toggle this. But if you have any dates in that workbook, they'll change by 4 years and one day. If c2 is the following day, you could do this: =c2-c3+if(c2<c3,24,0) or shorter =c2-c3+(c2<c3) A more robust way would be to enter both the date and time in each cell. Art wrote: Dodo & William I have encountered this error. Could you tell me what I'm missing. c3 = 22:47:00 c2 = 00:01:00 answer: ############## I only get the above answer when using the midnight time. "Art" wrote: Thank you Dodo & William "Art" wrote: Need Help.. I would like to subtract the end time(hh:mm:ss) from the start time(hh:mm:ss) to get the duration (HH:MM:SS) of how long a job took to process. Thanks. -- Dave Peterson |
#7
|
|||
|
|||
Thanks Dave that did it..
"Dave Peterson" wrote: Did you use: =c2-c3 If you did, then when excel sees negative times (or dates), it shows them as ####'s. You can avoid this by using the 1904 base date system. Tools|Options|calculation tab is where you'd toggle this. But if you have any dates in that workbook, they'll change by 4 years and one day. If c2 is the following day, you could do this: =c2-c3+if(c2<c3,24,0) or shorter =c2-c3+(c2<c3) A more robust way would be to enter both the date and time in each cell. Art wrote: Dodo & William I have encountered this error. Could you tell me what I'm missing. c3 = 22:47:00 c2 = 00:01:00 answer: ############## I only get the above answer when using the midnight time. "Art" wrote: Thank you Dodo & William "Art" wrote: Need Help.. I would like to subtract the end time(hh:mm:ss) from the start time(hh:mm:ss) to get the duration (HH:MM:SS) of how long a job took to process. Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
Duration | Excel Discussion (Misc queries) | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
how do i calculate minutes between two times? | Excel Discussion (Misc queries) | |||
Not able to calculate. | Excel Worksheet Functions |