Time calculations

  • Thread starter Thread starter NEHicks
  • Start date Start date
N

NEHicks

I am trying to discover a formula that will allow me to subtract 1/2
hour for lunch if the scheduled hours worked are over 8.0 hours.
There is what I have so far:

Start Time End Time OT Hours
7:00 15:30 8:30 [formula: =MOD(F5-E5,1) ]

I know this is simple but I have been trying so many different
formulas to no avail that I am hoping someone can help.
 
This worked perfectly. Thank you

T. Valko said:
Try this:

=MOD(F5-E5,1)-((MOD(F5-E5,1)*24>8)*30/1440)

--
Biff
Microsoft Excel MVP


NEHicks said:
I am trying to discover a formula that will allow me to subtract 1/2
hour for lunch if the scheduled hours worked are over 8.0 hours.
There is what I have so far:

Start Time End Time OT Hours
7:00 15:30 8:30 [formula: =MOD(F5-E5,1) ]

I know this is simple but I have been trying so many different
formulas to no avail that I am hoping someone can help.
Click to expand...
Click to expand...
 
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


NEHicks said:
This worked perfectly. Thank you

T. Valko said:
Try this:

=MOD(F5-E5,1)-((MOD(F5-E5,1)*24>8)*30/1440)

--
Biff
Microsoft Excel MVP


NEHicks said:
I am trying to discover a formula that will allow me to subtract 1/2
hour for lunch if the scheduled hours worked are over 8.0 hours.
There is what I have so far:

Start Time End Time OT Hours
7:00 15:30 8:30 [formula: =MOD(F5-E5,1) ]

I know this is simple but I have been trying so many different
formulas to no avail that I am hoping someone can help.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top