| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for hr worked that cross 12:00 am
I need the formula that will figure hrs worked in a shift that starts in one
day and ends in the next. Excel 2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for hr worked that cross 12:00 am
=MOD(A2-A1,1)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "dbow" wrote in message ... I need the formula that will figure hrs worked in a shift that starts in one day and ends in the next. Excel 2003 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for hr worked that cross 12:00 am
Try this:-
=IF(A1B1,B1+1-A1,B1-A1) Formatted as hh:mm Mike "dbow" wrote: I need the formula that will figure hrs worked in a shift that starts in one day and ends in the next. Excel 2003 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for hr worked that cross 12:00 am
=MOD(B2-A2,1) and format as [hh]:mm.
If you want decimal hours, then =MOD(B2-A2,1) and format as General or Number. -- David Biddulph "dbow" wrote in message ... I need the formula that will figure hrs worked in a shift that starts in one day and ends in the next. Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to work out hours worked | Excel Discussion (Misc queries) | |||
| Formula doesn't work this morning, but worked for 2 years now | Excel Worksheet Functions | |||
| Need formula to calculate hours worked | Excel Discussion (Misc queries) | |||
| What is wrong with this IF formula, it worked fine for a while? | Excel Discussion (Misc queries) | |||
| Formula that will represent years & months worked | Excel Discussion (Misc queries) | |||
Linear Mode
