| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add time formula
I am trying to add these times and it keeps giving me 23:55 for total hours.
i know this is wrong can some one help me? column a column b column c 7:30 PM 9:30 PM 2:00 8:45 PM 5:30 AM 8:45 8:15 PM 1:10 AM 4:55 8:15 PM 2:00 AM 5:45 8:15 PM 2:00 AM 5:45 8:15 PM 4:30 AM 8:15 8:15 PM 2:00 AM 5:45 23:55 this is the formula that i used =SUM(C1:C8) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time formula (difference of predicted and actual time) | Excel Discussion (Misc queries) | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| convert from percentage of time to time using complex formula in . | Excel Worksheet Functions | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Threaded Mode
