View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Izzy Izzy is offline
external usenet poster
 
Posts: 8
Default Time formulas in Excel

aCan anyone help please?

I am trying to put together a spreadsheet that will keep track of my hours
worked in a month, on different days. I have 2 rates at work. On day shift
rate, and a night shift rate. sometimes I work 09:00 till 18:00 at rate one,
and sometimes 22:00 till 06:00 at rate 2. The days vary, and I can get it to
work my day shift, but not my night shift. The calculation cell needs to be
able to calculate the difference in both shifts. Thanks for the help :)