Report

IF Function Time [Solved]

Ask a question Ashakil - Last answered on Apr 11, 2016 10:07AM by Ashakil
Hello,

I am trying to make a rota and I need help with a formula.

A1 B1 C1
07:00:00 14:30:00 =b1-a1

The person starts work at 7am and finished at 14h30. C1 represents how many hours they work (which the result is 7h30 or 07:30:00)
However when someone works over 6 hours, I need 30 minutes taken off automatically for their break which they do not get paid for. If they work only 6 hours or less then I want the result to just show 'b1-a1'. Can you help please?
See more 
Helpful
+0
moins plus
Ashakil, Good morning.

Try to use:

=IF(B1-A1>TIME(6,0,0),(B1-A1-TIME(0,30,0)),B1-A1)

Please, tell us if it worked for you.

I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Ashakil- Apr 11, 2016 10:07AM
It worked!! Thank you. I had to remember to convert the cell with the answer into time format afterwards but it worked very well.

Thank you again
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!