Excel
I have made a rota for several staff
I can auto add the days hours but am unable to add the wekks hours Date Day Neil On Off Tot 29-Jul-05 Fri 9:30 22:00 12:30 30-Jul-05 Sat 9:30 22:00 12:30 31-Jul-05 Sun 9:30 22:00 12:30 01-Aug-05 Mon 9:30 22:00 12:30 02-Aug-05 Tues 9:30 22:00 12:30 03-Aug-05 Wed 9:30 22:00 12:30 04-Aug-05 Thur 9:30 22:00 12:30 Total Hours 15:30 This is a sample Any help please |
Hi Sue:
What you are doing is correct. The tot for each day in your example is 12:30. Formatted as a number this is .52, This really means 52% of 24 hours. If you add the 7 daily tots to form a weekly tot, you will get 3.65. This is the same as 87.5 hours -- Gary's Student "sue walton" wrote: I have made a rota for several staff I can auto add the days hours but am unable to add the wekks hours Date Day Neil On Off Tot 29-Jul-05 Fri 9:30 22:00 12:30 30-Jul-05 Sat 9:30 22:00 12:30 31-Jul-05 Sun 9:30 22:00 12:30 01-Aug-05 Mon 9:30 22:00 12:30 02-Aug-05 Tues 9:30 22:00 12:30 03-Aug-05 Wed 9:30 22:00 12:30 04-Aug-05 Thur 9:30 22:00 12:30 Total Hours 15:30 This is a sample Any help please |
The cell for your total time should be formated to this. FORMAT / CELLS / CUSTOM [HH]:MM This will keep the hours from rolling over at the 24th hour. Matt -- Flintstone ------------------------------------------------------------------------ Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310 View this thread: http://www.excelforum.com/showthread...hreadid=391565 |
All times are GMT +1. The time now is 05:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com