Time Help

[Brian Gallagher]

I have a working timesheet for a week and I need to calculate the total
number of hours worked for that week against the no of hours that should
have been worked.

In Access I would use the Datediff function but in excel that looks
different.

Any ideas?

Thanks in advance

Brian

 

[Frank Kabel]

Hi Brian
you can simply add the times you have worked (only format the target
cell with the custom format [hh]:mm). To compare two times you may
subtract them. For more information about dates/times in Excel you may
have a look at
http://www.cpearson.com/excel/datetime.htm

 

[Bob Phillips]

=H1-SUM(A1:A10)

where H1 is the target hours, A1:A10 is the hours worked

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)