Help with Addition of Hours & Minutes

[Nhadya]

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

 

[Ian]

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

 

[Nhadya]

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