| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
figuring total time
How do i take two times eg. 13:30:34 and 13:31:34 and in a third cell return
the total time that was spent on a call, in this case 1 minute. 12:30:10 and 13:40:20 = 1 hour 10 minutes 10 seconds Military start time is in cell A1 end time is in cell B1 and total time is in cell C1. NOTE: call times can start before midnight and then go into the next day if that makes a difference to a formula. Thank You, Brian |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
figuring total time
Try:
=(B1-A1+(B1<A1)) "Brian" wrote: How do i take two times eg. 13:30:34 and 13:31:34 and in a third cell return the total time that was spent on a call, in this case 1 minute. 12:30:10 and 13:40:20 = 1 hour 10 minutes 10 seconds Military start time is in cell A1 end time is in cell B1 and total time is in cell C1. NOTE: call times can start before midnight and then go into the next day if that makes a difference to a formula. Thank You, Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating total time | Excel Worksheet Functions | |||
| Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Total TIme worked | Excel Worksheet Functions | |||
| Percent of total in Pivot tables | Excel Worksheet Functions | |||
Linear Mode
