How to modify my formula to take 1 hour off?

Ask Question

Asked 4 years ago

Modified 2 years, 7 months ago

Viewed 21 times

E6 = Finish Time.
B6 = Start Time.

My working formula: =E6-B6+(E6<B6) =Time worked in Hours/Minutes

How should I modify my formula to "minus 1 Hour" for a break?

Sounds easy, but I can't get this to work. Any help, please?

user0

25.8k8 gold badges48 silver badges76 bronze badges

asked May 28, 2019 at 14:19

Darren Stanley

111 bronze badge

Add a comment |

1 Answer 1

Sorted by:

append -1/24 (1 hour for a total of 24 hours per day)
```
=E6-B6+(E6 < B6)-1/24
```

answered May 28, 2019 at 15:18

user0

25.8k8 gold badges48 silver badges76 bronze badges

Add a comment |

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.