Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding up Time like decimal values ??
Hi
I need to sum up a column displaying time (4:00 or 6:30) but display the sum as decimal......?!?!?! or at least get the answer in Hours:minutes even if Hours 24 ....?!??! I can do this in VB and other soft but can I do it in Excel directly??? Kjell |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding up Time like decimal values ??
Kjell,
For 24 hours, just format the cell as [h]:mm, and add up as normal. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Kjell" wrote in message ... Hi I need to sum up a column displaying time (4:00 or 6:30) but display the sum as decimal......?!?!?! or at least get the answer in Hours:minutes even if Hours 24 ....?!??! I can do this in VB and other soft but can I do it in Excel directly??? Kjell |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding up Time like decimal values ??
One way:
XL stores times as fractional days, so if you're adding A1:A10: Hours:Minutes display: =SUM(A1:A10) then Format/Cells/Number/Custom [h]:mm decimal hours: =SUM(A1:A10)*24 In article , "Kjell" wrote: Hi I need to sum up a column displaying time (4:00 or 6:30) but display the sum as decimal......?!?!?! or at least get the answer in Hours:minutes even if Hours 24 ....?!??! I can do this in VB and other soft but can I do it in Excel directly??? Kjell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Adding up time values | Excel Worksheet Functions | |||
Summing decimal values to time | New Users to Excel | |||
Adding a decimal hours to a starting time to give a finishing tim | Excel Discussion (Misc queries) | |||
SUBTRACTING TIME VALUES INSTEAD OF DECIMAL!! | Excel Discussion (Misc queries) |