| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working night and day..... Timesheet
In Out In Out The total time I
get Overtime 15:00 18:30 19:20 02:00 -13,83 0,00 I'm using this Formula: =IF((((D13-C13)+(F13-E13))*24)24;8;((D13-C13)+(F13-E13))*24). Why doesn't this work? I get negative hours in the total worked hours and no overtime... My computer doesn't understand the new comming day... This formula works when I'm working daytime... Hope there's somebody that can help me Thnx!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Working night and day..... Timesheet
Try this to get total hours worked (as decimal hours i.e. 6 hours 30 minutes
will be shown as 6.50 hours) =((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24 HTH "Kjaltrik" wrote: In Out In Out The total time I get Overtime 15:00 18:30 19:20 02:00 -13,83 0,00 I'm using this Formula: =IF((((D13-C13)+(F13-E13))*24)24;8;((D13-C13)+(F13-E13))*24). Why doesn't this work? I get negative hours in the total worked hours and no overtime... My computer doesn't understand the new comming day... This formula works when I'm working daytime... Hope there's somebody that can help me Thnx!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Working night and day..... Timesheet
Thank you very much!!! It worked.
But now the overtime cell still stands on zero... I have overtime over 7,5 hours The formula I use there is =IF(((D13-C13)+(F13-E13))*247,5;((D13-C13)+(F13-E13))*24-7,5;) Toppers skrev: Try this to get total hours worked (as decimal hours i.e. 6 hours 30 minutes will be shown as 6.50 hours) =((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24 HTH "Kjaltrik" wrote: In Out In Out The total time I get Overtime 15:00 18:30 19:20 02:00 -13,83 0,00 I'm using this Formula: =IF((((D13-C13)+(F13-E13))*24)24;8;((D13-C13)+(F13-E13))*24). Why doesn't this work? I get negative hours in the total worked hours and no overtime... My computer doesn't understand the new comming day... This formula works when I'm working daytime... Hope there's somebody that can help me Thnx!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Working night and day..... Timesheet
Overtime hours:
=MAX(G1-7.5,0) where G1 contains total hours worked OR =MAX(((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24-7.5,0) HTH "Kjaltrik" wrote: Thank you very much!!! It worked. But now the overtime cell still stands on zero... I have overtime over 7,5 hours The formula I use there is =IF(((D13-C13)+(F13-E13))*247,5;((D13-C13)+(F13-E13))*24-7,5;) Toppers skrev: Try this to get total hours worked (as decimal hours i.e. 6 hours 30 minutes will be shown as 6.50 hours) =((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24 HTH "Kjaltrik" wrote: In Out In Out The total time I get Overtime 15:00 18:30 19:20 02:00 -13,83 0,00 I'm using this Formula: =IF((((D13-C13)+(F13-E13))*24)24;8;((D13-C13)+(F13-E13))*24). Why doesn't this work? I get negative hours in the total worked hours and no overtime... My computer doesn't understand the new comming day... This formula works when I'm working daytime... Hope there's somebody that can help me Thnx!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Working night and day..... Timesheet
Thank you very much for your time and help!
Everything is working good now!! Toppers skrev: Overtime hours: =MAX(G1-7.5,0) where G1 contains total hours worked OR =MAX(((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24-7.5,0) HTH "Kjaltrik" wrote: Thank you very much!!! It worked. But now the overtime cell still stands on zero... I have overtime over 7,5 hours The formula I use there is =IF(((D13-C13)+(F13-E13))*247,5;((D13-C13)+(F13-E13))*24-7,5;) Toppers skrev: Try this to get total hours worked (as decimal hours i.e. 6 hours 30 minutes will be shown as 6.50 hours) =((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24 HTH "Kjaltrik" wrote: In Out In Out The total time I get Overtime 15:00 18:30 19:20 02:00 -13,83 0,00 I'm using this Formula: =IF((((D13-C13)+(F13-E13))*24)24;8;((D13-C13)+(F13-E13))*24). Why doesn't this work? I get negative hours in the total worked hours and no overtime... My computer doesn't understand the new comming day... This formula works when I'm working daytime... Hope there's somebody that can help me Thnx!! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Working night and day..... Timesheet
No problem ... thank you for the feedback.
"Kjaltrik" wrote: Thank you very much for your time and help! Everything is working good now!! Toppers skrev: Overtime hours: =MAX(G1-7.5,0) where G1 contains total hours worked OR =MAX(((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24-7.5,0) HTH "Kjaltrik" wrote: Thank you very much!!! It worked. But now the overtime cell still stands on zero... I have overtime over 7,5 hours The formula I use there is =IF(((D13-C13)+(F13-E13))*247,5;((D13-C13)+(F13-E13))*24-7,5;) Toppers skrev: Try this to get total hours worked (as decimal hours i.e. 6 hours 30 minutes will be shown as 6.50 hours) =((D1-C1)+(D1<C1)+(F1-E1)+(F1<E1))*24 HTH "Kjaltrik" wrote: In Out In Out The total time I get Overtime 15:00 18:30 19:20 02:00 -13,83 0,00 I'm using this Formula: =IF((((D13-C13)+(F13-E13))*24)24;8;((D13-C13)+(F13-E13))*24). Why doesn't this work? I get negative hours in the total worked hours and no overtime... My computer doesn't understand the new comming day... This formula works when I'm working daytime... Hope there's somebody that can help me Thnx!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
