calculate hours on work sheet
 

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




"monish74" wrote in message
...
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

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




"monish74" wrote in
message
...
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


.