need to subtract .50 from a cell if it is over 6.00
 

Here is the formula it works but I need it to also subtract .50 from I5 if I5
is greater then 6.00 after it is divided by 24 at the end, it is for a time
sheet to take out .30 min for lunch.


=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24))))

need to subtract .50 from a cell if it is over 6.00
 

See your other post.

=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(IF(I56,I5-0.5,I5)/24)))



--
Regards
Dave Hawley
www.ozgrid.com
"Jeff Brown" wrote in message
...
Here is the formula it works but I need it to also subtract .50 from I5 if
I5
is greater then 6.00 after it is divided by 24 at the end, it is for a
time
sheet to take out .30 min for lunch.


=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24))))

need to subtract .50 from a cell if it is over 6.00
 

Try this...

A1 = start time = 6:30 AM
B1 = end time = 3:00 PM

=MOD(B1-A1,1)-(MOD(B1-A1,1)0.25)*30/1440

Format as [h]:mm

--
Biff
Microsoft Excel MVP


"Jeff Brown" wrote in message
...
Here is the formula it works but I need it to also subtract .50 from I5 if
I5
is greater then 6.00 after it is divided by 24 at the end, it is for a
time
sheet to take out .30 min for lunch.


=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24))))

need to subtract .50 from a cell if it is over 6.00
 

Great Job Thanks Alot
--
Chris


"T. Valko" wrote:

Try this...

A1 = start time = 6:30 AM
B1 = end time = 3:00 PM

=MOD(B1-A1,1)-(MOD(B1-A1,1)0.25)*30/1440

Format as [h]:mm

--
Biff
Microsoft Excel MVP


"Jeff Brown" wrote in message
...
Here is the formula it works but I need it to also subtract .50 from I5 if
I5
is greater then 6.00 after it is divided by 24 at the end, it is for a
time
sheet to take out .30 min for lunch.


=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24))))


.

need to subtract .50 from a cell if it is over 6.00
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
Great Job Thanks Alot
--
Chris


"T. Valko" wrote:

Try this...

A1 = start time = 6:30 AM
B1 = end time = 3:00 PM

=MOD(B1-A1,1)-(MOD(B1-A1,1)0.25)*30/1440

Format as [h]:mm

--
Biff
Microsoft Excel MVP


"Jeff Brown" wrote in message
...
Here is the formula it works but I need it to also subtract .50 from I5
if
I5
is greater then 6.00 after it is divided by 24 at the end, it is for a
time
sheet to take out .30 min for lunch.


=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24))))


.