Time calculations

[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.

 

[T. Valko]

Try this:

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

 

[Bob Phillips]

=MOD(F5-E5,1)-(MOD(F5-E5,1)>--"08:00")/48

 

[NEHicks]

This worked perfectly. Thank you

Try this:

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

--
Biff
Microsoft Excel MVP

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.

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

This worked perfectly. Thank you

Try this:

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

--
Biff
Microsoft Excel MVP

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.