I recently was put in charge of payroll at my job, and can't quite seem to wrap my head around converting hours into decimals. We break it down to 1/4 hours. Math is like a foreign language to me! If there was some sort of converter that I could, say, put in the time someone clocked in, and the time they clocked out, and then it would tell me that they worked (for example) 7.75 hours. Are there any software programs that will accomplish this for me? Or maybe a website with some sort of javascript? Or maybe an excell formula? I am at the mercy of technology!
2007-05-26
12:17:07
·
5 answers
·
asked by
dave_g_28
2
in
Business & Finance
➔ Other - Business & Finance
Pretend that I'm in the 3rd grade. ;) I need to figure out how to get the decimal number. Example: John clocks in at 8:02am. He clocks out for lunch at 11:46am and clocks back in at 12:16pm. He clocks out for the day at 2:17pm. How do I get the hours worked in decimal form?
2007-05-26
12:35:16 ·
update #1