Help with Addition of Hours & Minutes

N

Nhadya

Joined
Oct 8, 2007
Messages
2
Reaction score
0
Hello there,

I am working on an Excel Spreadsheet via Windows Vista, whereby I am logging staff hours every day.

I have been able to obtain the time between two points e.g. 9am to 5pm (with thanks to this site via a Google search), but I am unable to figure out how to add up the the results of the week.

e.g. 8hrs Monday, 6 hours 30 minutes Tuesday, 2 hours 15 minutes Wednesday and so on, up to 38 -50 hours for each employee

I have looked at the Microsoft site, but as I am adding up to more than the 24 hours which their solution achieves.

Can any one assist please?

Kind regards
Linda Eden
 
Why not convert the time between the two points for each day... i.e:

9-5 = 480min (8*60)

then add up the minutes from each day of the week, and then convert back to hours :)
 
Thanks for Advice on Addition of Time Problem

Thank you for your advice, which has been helpful and very much appreciated.

Kind regards
Linda Eden
 
Back
Top