I am trying to compute a formula which will allow me to figure out the hours worked for a person. It worked very well until I ran into third shift people who would work beyond 12:00am.
I then found the following formula:
=TEXT(IF(B1<A1,1-A1+B1,B1-A1),"hh:mm")
However this returns the time they worked and not a number.
For example:
Time In 5:30 PM
Time Out 2:00 AM
Total Time worked 8:30 is what is returned
What I want is 8.5
Unfortunately, I think I am making this harder than it is and I am drawing a blank.
Thank you
Jay
I then found the following formula:
=TEXT(IF(B1<A1,1-A1+B1,B1-A1),"hh:mm")
However this returns the time they worked and not a number.
For example:
Time In 5:30 PM
Time Out 2:00 AM
Total Time worked 8:30 is what is returned
What I want is 8.5
Unfortunately, I think I am making this harder than it is and I am drawing a blank.
Thank you
Jay