Originally Posted by
rcterrell
I'll try to explain this one as clear as possible. Here's the setup:
A1 - 08:00
B1 - 12:24
C1 - 13:15
D1 - 17:01
E1 - (Total Hours)
Okay. As you can see E1 is adding my employee's time in, lunch out, etc.
E1 has a formula already: =(B1<A1)+B1-A1+(D1<C1)+D1-C1
and the E1 cell uses [H]:mm custom format.
My problem is this: I need to have E1 round to the nearest tenth of an hour, but haven't been able to figure out the formula or how to nest the formula in addition to what I already have in E1.
Any help will be greatly appreciated!
Bookmarks