Excel Formula

P

Putts

Can I have a formula in Excel for a person starting work at 7pm monday and
finishing work at 9am Tuesday - the result should be 14 hours worked but it
comes up -10?
 
B

Barb Reinhardt

Try formatting the two fields so that they show both date and time. I'm
guessing they both show the same date.
 
G

Gary''s Student

Format A1 & A2 as

Format > Cells... > Number > Date > 3/14/01 1:30 PM

Format A3 as:

Custom > [h]

in A1 thru A2:

6/18/07 7:00 PM
6/19/07 9:00 AM

In A3:

=A2-A1

will display 14
 
D

David Biddulph

If they do show the same date and you're getting -10:00 from =B1-A1, you may
be able to fudge the answer by using =MOD(B1-A1,1)
 
Top