Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elapse Time
I would to calculate the elapsed time between the start and end
Time, to the nearest second. So that I can generate a chart to graphically show what day the job took longer to process. Example: Date: start end Monday 11:00 12:33 Tuesday 11:05 12:05 Wednesday 11:10 11:30 Any suggestion would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elapse Time
In D1 put ......ElapsedTime
In D3 put.......=C2-B2 and copy this formula down column D hth Vaya con Dios, Chuck, CABGx3 "Art" wrote: I would to calculate the elapsed time between the start and end Time, to the nearest second. So that I can generate a chart to graphically show what day the job took longer to process. Example: Date: start end Monday 11:00 12:33 Tuesday 11:05 12:05 Wednesday 11:10 11:30 Any suggestion would be appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elapse Time
Chuck, Would it be possible to change 1.86 to 2.26 ( hh:mm ).
(End Time) 9.24 - (Start Time) 7.38 = (Elapsed Time) 1.86 So that when the chart is displayed the folks don't have to the math. Really appeciate.. "CLR" wrote: In D1 put ......ElapsedTime In D3 put.......=C2-B2 and copy this formula down column D hth Vaya con Dios, Chuck, CABGx3 "Art" wrote: I would to calculate the elapsed time between the start and end Time, to the nearest second. So that I can generate a chart to graphically show what day the job took longer to process. Example: Date: start end Monday 11:00 12:33 Tuesday 11:05 12:05 Wednesday 11:10 11:30 Any suggestion would be appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elapse Time
With EndTime in C2 and StartTime in B2....
=INT(C2-B2)+INT((C2-B2-INT(C2-B2))*100/60)+(((C2-B2-INT(C2-B2))*100/60-INT((C2-B2-INT(C2-B2))*100/60))*60)/100 All in one cell, watch out for word-wrap Vaya con Dios, Chuck, CABGx3 "Art" wrote: Chuck, Would it be possible to change 1.86 to 2.26 ( hh:mm ). (End Time) 9.24 - (Start Time) 7.38 = (Elapsed Time) 1.86 So that when the chart is displayed the folks don't have to the math. Really appeciate.. "CLR" wrote: In D1 put ......ElapsedTime In D3 put.......=C2-B2 and copy this formula down column D hth Vaya con Dios, Chuck, CABGx3 "Art" wrote: I would to calculate the elapsed time between the start and end Time, to the nearest second. So that I can generate a chart to graphically show what day the job took longer to process. Example: Date: start end Monday 11:00 12:33 Tuesday 11:05 12:05 Wednesday 11:10 11:30 Any suggestion would be appreciated. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elapse Time
Thanks Chuck that worked..
"CLR" wrote: With EndTime in C2 and StartTime in B2.... =INT(C2-B2)+INT((C2-B2-INT(C2-B2))*100/60)+(((C2-B2-INT(C2-B2))*100/60-INT((C2-B2-INT(C2-B2))*100/60))*60)/100 All in one cell, watch out for word-wrap Vaya con Dios, Chuck, CABGx3 "Art" wrote: Chuck, Would it be possible to change 1.86 to 2.26 ( hh:mm ). (End Time) 9.24 - (Start Time) 7.38 = (Elapsed Time) 1.86 So that when the chart is displayed the folks don't have to the math. Really appeciate.. "CLR" wrote: In D1 put ......ElapsedTime In D3 put.......=C2-B2 and copy this formula down column D hth Vaya con Dios, Chuck, CABGx3 "Art" wrote: I would to calculate the elapsed time between the start and end Time, to the nearest second. So that I can generate a chart to graphically show what day the job took longer to process. Example: Date: start end Monday 11:00 12:33 Tuesday 11:05 12:05 Wednesday 11:10 11:30 Any suggestion would be appreciated. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elapse Time
Chuck, sorry for the inconvenience but hopefully these question will help
others too. Your formula worked fine till I had to enter the time after midnight. (Start Time) 22.42 €“ (End time) 00.59 = ( Elapsed time) -21.83 How can I get the -21.83 to 2.17 ? I appreciate your Help.. "CLR" wrote: With EndTime in C2 and StartTime in B2.... =INT(C2-B2)+INT((C2-B2-INT(C2-B2))*100/60)+(((C2-B2-INT(C2-B2))*100/60-INT((C2-B2-INT(C2-B2))*100/60))*60)/100 All in one cell, watch out for word-wrap Vaya con Dios, Chuck, CABGx3 "Art" wrote: Chuck, Would it be possible to change 1.86 to 2.26 ( hh:mm ). (End Time) 9.24 - (Start Time) 7.38 = (Elapsed Time) 1.86 So that when the chart is displayed the folks don't have to the math. Really appeciate.. "CLR" wrote: In D1 put ......ElapsedTime In D3 put.......=C2-B2 and copy this formula down column D hth Vaya con Dios, Chuck, CABGx3 "Art" wrote: I would to calculate the elapsed time between the start and end Time, to the nearest second. So that I can generate a chart to graphically show what day the job took longer to process. Example: Date: start end Monday 11:00 12:33 Tuesday 11:05 12:05 Wednesday 11:10 11:30 Any suggestion would be appreciated. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elapse Time
You can't solve that problem properly unless you use DATES as well as times.
See Chip's page for much more info about working with TIMES......... http://www.cpearson.com/excel/datetime.htm#AddingTimes hth Vaya con Dios, Chuck, CABGx3 "Art" wrote: Chuck, sorry for the inconvenience but hopefully these question will help others too. Your formula worked fine till I had to enter the time after midnight. (Start Time) 22.42 €“ (End time) 00.59 = ( Elapsed time) -21.83 How can I get the -21.83 to 2.17 ? I appreciate your Help.. "CLR" wrote: With EndTime in C2 and StartTime in B2.... =INT(C2-B2)+INT((C2-B2-INT(C2-B2))*100/60)+(((C2-B2-INT(C2-B2))*100/60-INT((C2-B2-INT(C2-B2))*100/60))*60)/100 All in one cell, watch out for word-wrap Vaya con Dios, Chuck, CABGx3 "Art" wrote: Chuck, Would it be possible to change 1.86 to 2.26 ( hh:mm ). (End Time) 9.24 - (Start Time) 7.38 = (Elapsed Time) 1.86 So that when the chart is displayed the folks don't have to the math. Really appeciate.. "CLR" wrote: In D1 put ......ElapsedTime In D3 put.......=C2-B2 and copy this formula down column D hth Vaya con Dios, Chuck, CABGx3 "Art" wrote: I would to calculate the elapsed time between the start and end Time, to the nearest second. So that I can generate a chart to graphically show what day the job took longer to process. Example: Date: start end Monday 11:00 12:33 Tuesday 11:05 12:05 Wednesday 11:10 11:30 Any suggestion would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
Hot key for time? | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
time differences in a column | Excel Worksheet Functions |