| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with adding up hours and mins please
Hi I am trying to add up the total number of hours worked by staff over a
montly period by inserting times in colums for days 1 - 31. When I add formula =sum(a1:a31) the total is way out because the times mins are being treated as tenths and hundreths and the total for hours gets to 24 then reverts back to one. how do I get hours and mins to add up as hours and mins ? Cheers Baz |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with adding up hours and mins please
Format the the total cell as [h]:mm
The [ ] will keep the hours from rolling over. -- Biff Microsoft Excel MVP "baz" wrote in message ... Hi I am trying to add up the total number of hours worked by staff over a montly period by inserting times in colums for days 1 - 31. When I add formula =sum(a1:a31) the total is way out because the times mins are being treated as tenths and hundreths and the total for hours gets to 24 then reverts back to one. how do I get hours and mins to add up as hours and mins ? Cheers Baz |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with adding up hours and mins please
T - Spot on Thank you - just done a dummy test and it looks ok - can go to
work on Monday and be a right smarty pants !!! regards Baz "T. Valko" wrote: Format the the total cell as [h]:mm The [ ] will keep the hours from rolling over. -- Biff Microsoft Excel MVP "baz" wrote in message ... Hi I am trying to add up the total number of hours worked by staff over a montly period by inserting times in colums for days 1 - 31. When I add formula =sum(a1:a31) the total is way out because the times mins are being treated as tenths and hundreths and the total for hours gets to 24 then reverts back to one. how do I get hours and mins to add up as hours and mins ? Cheers Baz |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with adding up hours and mins please
Cool! Thanks for the feedback!
-- Biff Microsoft Excel MVP "baz" wrote in message ... T - Spot on Thank you - just done a dummy test and it looks ok - can go to work on Monday and be a right smarty pants !!! regards Baz "T. Valko" wrote: Format the the total cell as [h]:mm The [ ] will keep the hours from rolling over. -- Biff Microsoft Excel MVP "baz" wrote in message ... Hi I am trying to add up the total number of hours worked by staff over a montly period by inserting times in colums for days 1 - 31. When I add formula =sum(a1:a31) the total is way out because the times mins are being treated as tenths and hundreths and the total for hours gets to 24 then reverts back to one. how do I get hours and mins to add up as hours and mins ? Cheers Baz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum of Hours/mins | Excel Worksheet Functions | |||
| Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
| How Do I Get The Difference In Hours and Mins | Excel Worksheet Functions | |||
| IF statement for hours/mins | Excel Discussion (Misc queries) | |||
| Tracking Time (Hours/Mins) | Excel Discussion (Misc queries) | |||
Linear Mode
