Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TimeSheet calculatons Overnights
We have a shift that runs from 19:00 until 07:00 the next day. How can I get
Excel to calculate the hours without the necessity of adding a date to the cell. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TimeSheet calculatons Overnights
Hi Don
With start time in A1 and end time in B1 =MOD(B1-A1,1) -- Regards Roger Govier "DonElston" wrote in message ... We have a shift that runs from 19:00 until 07:00 the next day. How can I get Excel to calculate the hours without the necessity of adding a date to the cell. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TimeSheet calculatons Overnights
=MOD(B1-A1,1)
or =(B1-A1)+(A1B1) "DonElston" wrote: We have a shift that runs from 19:00 until 07:00 the next day. How can I get Excel to calculate the hours without the necessity of adding a date to the cell. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TimeSheet calculatons Overnights
Start time =A1
End time = B1 Try:- =(B1-A1+(B1<A1))*24 Mike "DonElston" wrote: We have a shift that runs from 19:00 until 07:00 the next day. How can I get Excel to calculate the hours without the necessity of adding a date to the cell. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TimeSheet calculatons Overnights
THanks so much, it worked great.
DOn "Teethless mama" wrote: =MOD(B1-A1,1) or =(B1-A1)+(A1B1) "DonElston" wrote: We have a shift that runs from 19:00 until 07:00 the next day. How can I get Excel to calculate the hours without the necessity of adding a date to the cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate total child custody overnights? | Excel Discussion (Misc queries) | |||
Timesheet | Excel Worksheet Functions | |||
Timesheet | Excel Worksheet Functions | |||
timesheet with OT | New Users to Excel | |||
Timesheet | Excel Worksheet Functions |