| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
Linear Mode
