| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding up hours
HI all, how to I add up numbers and convert them hours and minutes for eg
7 +7+7:40+7 =28hrs 40 mins Thanks all -- delmac |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding up hours
Assume your times are in cells A1:A4; result would be this:
=INT(SUM(A1:A4))*24+HOUR(SUM(A1:A4))&"hrs, "&MINUTE(SUM(A1:A4))&"min" Make sure all times are entered in time format, not straight numbers; i.e 07:00 instead of 7. -- - K Dales "delmac" wrote: HI all, how to I add up numbers and convert them hours and minutes for eg 7 +7+7:40+7 =28hrs 40 mins Thanks all -- delmac |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding up hours
On Fri, 3 Feb 2006 04:44:10 -0800, delmac
wrote: HI all, how to I add up numbers and convert them hours and minutes for eg 7 +7+7:40+7 =28hrs 40 mins Thanks all If they are all entered as time: 7:00 7:00 7:40 7:00 Then just SUM the range and format the result cell as [h]:mm (Format/Cells/Number Custom Type: [h]:mm) Note the brackets around the h -- this will keep the hours from "rolling over" every 24. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Hours | Excel Discussion (Misc queries) | |||
| Adding hours | Excel Discussion (Misc queries) | |||
| Need help adding hours exceeding 24 hours | Excel Worksheet Functions | |||
| adding like job hours | Excel Discussion (Misc queries) | |||
| Adding hours to a date | Excel Worksheet Functions | |||
Linear Mode
