IF Function Time [Solved/Closed]

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

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?
plus moins
Ashakil, Good morning.

Try to use:


Please, tell us if it worked for you.

I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
Ashakil- Apr 11, 2016 at 10:07 AM
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

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!