calculate hours on work sheet

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

Guest

I am trying to calculate hours on a work schedual with 1 cell hours worked
like 8:15am-4:15pm and the cell under it reads 8 hours as the answer

probably simple but i'm lost
 
Monish

I don't see the problem from your question.
I have 8:15am in A1 and 4:15pm in B1

B1-A1 produce a row of #'s (as it should)
A1-B1 produces your result.

The following is based on the assumption you are actually trying to
calculate across midnight:

To calculate time across midnight, you need to enter the number of days into
the equation:
=IF(B1-A1>=0,B1-A1,NumberOfDays+B1-A1)
If you are totally sure nothing will be scheduled more than 24 hours:
=IF(B1-A1>=0,B1-A1,1+B1-A1)

Use a custom formation on the cells containing the result [h]:mm if time is
expected to extend more than 24 hours.

HTH
Steve
 
I don't see the problem from your question.

I think they have 8:15am-4:15pm all in a single cell.

Biff
-----Original Message-----
Monish

I don't see the problem from your question.
I have 8:15am in A1 and 4:15pm in B1

B1-A1 produce a row of #'s (as it should)
A1-B1 produces your result.

The following is based on the assumption you are actually trying to
calculate across midnight:

To calculate time across midnight, you need to enter the number of days into
the equation:
=IF(B1-A1>=0,B1-A1,NumberOfDays+B1-A1)
If you are totally sure nothing will be scheduled more than 24 hours:
=IF(B1-A1>=0,B1-A1,1+B1-A1)

Use a custom formation on the cells containing the result [h]:mm if time is
expected to extend more than 24 hours.

HTH
Steve




I am trying to calculate hours on a work schedual with 1 cell hours worked
like 8:15am-4:15pm and the cell under it reads 8 hours as the answer

probably simple but i'm lost
Click to expand...


.
Click to expand...
 
Back
Top