Hello everybody!
B2=0700 (start time)
C2=1530 (end time)
The formula I'm currently using is a simple (C2-B2)/100 function, but of course this yields "8.3" instead of "8.5"
Is there any way to convert my time input (interval of 15 minutes each) to the amount of hours worked (interval of 0.25 each)?
Bookmarks