Excel Formula
 

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?

Excel Formula
 

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

"Putts" wrote:

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?

Excel Formula
 

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
--
Gary''s Student - gsnu200731


"Putts" wrote:

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?

Excel Formula
 

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)
--
David Biddulph

"Barb Reinhardt" wrote in message
...
Try formatting the two fields so that they show both date and time. I'm
guessing they both show the same date.

"Putts" wrote:

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?

Excel Formula
 

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

Format cell as h:mm


"Putts" wrote:

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?