Hi all,
I am trying to total the hours each staff member has worked in a week.
The hours for each day are in cells formatted in custom hh:mm. When I calculate the weekly total I get the result in time format. So if a staff member has worked 25 hours the cell returns 01:00. I'm assuming I need to be using a different cell format just not sure which one.
Thanks in advance,
Luke
Bookmarks