I have a clock in - clock out worksheet. Should be simple, but for some entries (the last in the sample file), I have someone logging in at 10 pm and then clocking out the next day. Those entries are giving me trouble. Is there some formula that would be simple to use? Please see attached file.
Try this...
=MOD(F2-C2,1)
Format as h:mm
One of your results is wrong (I think).
On row 4 you have a time in of 10:00 PM and a time out of 2:00 AM with a net result of 20:00. The correct result should be 4:00.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Works. Awesome!
Good deal. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks