Forum Discussion
calculating hours
how do i calculate hours ex1. if 06:55 is rounded as 07:00, and 15:05 rounded is 15:00, and the answer should be in the form of 8.0 hours ex2. if 13:25 is rounded as 13:30 plus 20:35 rounded as ...
this is how I wanted, i dont know how it is rounded but at my work, 6:55 AM is 7:00 AM, whereas 3:36 PM is 3:45 PM, and total is 8 hours and 45 mins, and the hardest part is to show not 8:45 but 8.75
thank you very much.
I advise you to inquire about the algorithm of how work hours are calculated.
thats how it is at work, punches after 5 minutes after scheduled time is rounded up 15 minutes or 0.25 hour late, and punches 5 minutes before scheduled time rounded down 15 minutes or 0.25 hour early, ex: IN - 15:06
OUT - 19:50
TOTAL - 4.5 HOURS