Excel Formula

[Guest]

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?

 

[Guest]

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

 

[Guest]

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

 

[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)

 

[Guest]

=MOD(B1-A1,1)
or
=(B1-A1)+(A1>B1)

Format cell as h:mm