| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add up time and minutes in a spreadsheet?
I need to add the total time and minutes (hours worked) in a colum, but when
I use the =SUM(a1,a2) function it adds the numbers in hundredths and not time format. Example: Monday 7:55 NOT: Monday 7:55 Tuesday 8:10 Tuesday 8:10 = 16:05 = 15:65 I cant find anything in the help that addresses this. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for Adding Time | Excel Discussion (Misc queries) | |||
| Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Time Calculation in Minutes only ? | Excel Worksheet Functions | |||
| If Statement - in time not decimal minutes | Excel Worksheet Functions | |||
Threaded Mode
