I have the following formula:
=TEXT(D2-C2-TIME(,60,),"[h] \h\r\s: m \m\i\n\s")
It's taking out 60 minutes for lunch. Now I want to use this to calculate straight time and not deduct any time. How can this be modified?
Thank you!
I have the following formula:
=TEXT(D2-C2-TIME(,60,),"[h] \h\r\s: m \m\i\n\s")
It's taking out 60 minutes for lunch. Now I want to use this to calculate straight time and not deduct any time. How can this be modified?
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks