date and time calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What would my formula and format of cells be for calculating hours between dates and times.
Ex. start time Jan 2, 04 8 am to end time Jan 4, 04 5 pm. I DO NOT want my times or answers in military time.
If you could please give me an example of how to format each cell and the formula for each cell, it would be greatly appreciated. Thank you.
 
Matilda

In the UK I'd enter the start time as 2/1/04 8:
Excel will format this as 02/01/04 8:00 or whatever your
default setting is. Notice the space between the date and
the start time.

The formula for calulating the hours is
=IF(I8<I7,(I8+0.5)-I7) where I7 is the start and I8 is the
end. You will need to format the cell to time.

If people work night shift the formula will be more
complex.

Regards
Peter
-----Original Message-----
What would my formula and format of cells be for
Click to expand...
calculating hours between dates and times.
Ex. start time Jan 2, 04 8 am to end time Jan 4, 04 5
Click to expand...
pm. I DO NOT want my times or answers in military time.
If you could please give me an example of how to format
Click to expand...
each cell and the formula for each cell, it would be
greatly appreciated. Thank you.
 
Back
Top