| 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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add time formula
use custom format [hh]:mm
On Dec 8, 1:15*pm, JoRDaN wrote: 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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add time formula
I get 17:10 not 23:55. If it is summing and cycling around the 24 value then
the other answer applies, if it is not adding up correctly there is some other problem. -- __________________________________ HTH Bob "JoRDaN" wrote in message ... 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) |
| Reply |
| 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 | |||
Hybrid Mode
