Forum Discussion
Need help with formula
I need help I've made a work schedule, with time in and time out. I need help with a formula to subtract for one hour for lunch, with out showing a time in or out for lunch. Here is a clip of it.
Tuesday Jan 2,2018
8:15 AM 9:00
5:15 PM
7:45 AM 10:00
5:45 PM
Thank you.
Hi Christina
Hopefully I am interpreting right (I am assuming the time to the right of your AM/PM is time out), would something like this suit?
Formula
=(B2-A2)*24-1
Essentially just a formula to say (Time out + Time in) x 24 hours - 1 hour (lunch).
I've also attached the file I have mocked.
Good luck!
Cheers
Damien
Or as variant
=B2-A2-TIME(1,0,0)
