| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumation
Thats perfect. Thanks for the support.
"David Biddulph" wrote: If you want the answer in time format, leave out the multiplication by 24, and format as [h]:mm to cope with the wrap-round when the answer is more than 24 hours. If you want the answer in numbers of hours (as a decimal number), then your multiplication by 24 is right, but you need to format the answer as number or general. -- David Biddulph "Bikertyke" wrote in message ... Why when I try to sum 5 days worth of 07:35's does the answer equal 22:00. My formula {=sum(cell 1:cell 5)*24} I believe is correct as is the formatting, i've tried time and custom hh:mm. It should be so simple. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How am i able to populate a sumation for multiple sheets | Excel Worksheet Functions | |||
Hybrid Mode
