Excel 2003

[Andrew]

I am trying to create a formula to determine work hours.

Date & time is captured as ccyy/mm/dd hh:mm (start date / time - end date /
time) I also created a file for public holidays.

 

[FSt1]

hi
see these sites
http://www.cpearson.com/Excel/datetime.htm#AddingTimes
http://www.cpearson.com/Excel/overtime.htm

regards
FSt1

 

[Andrew]

Thank You this helped
--
Andrew

hi
see these sites
http://www.cpearson.com/Excel/datetime.htm#AddingTimes
http://www.cpearson.com/Excel/overtime.htm

regards
FSt1