Newsroom Update
New features come to Apple services this fall. Learn more >
New features come to Apple services this fall. Learn more >
Does anyone know how to easily convert clock in/out times to total hours & minutes? For example, if I clocked in to a job at 8:57 AM and clocked out at 11:23 - I am looking for a way to convert this to hours and minutes (2.26 or 2 hours & 26 minutes). TIA!
You can try this:
Line 2 gives result in Duration hours and minutes.
Line 3 gives result in decimal hours for use in multiplication by hourly rate, etc.
If you haven't done so already be sure to have a look at the templates at File > New in your menu. The 'Employee Schedule' template in particular may give you ideas on how to accomplish what you are trying to do.
SG
You can try this:
Line 2 gives result in Duration hours and minutes.
Line 3 gives result in decimal hours for use in multiplication by hourly rate, etc.
If you haven't done so already be sure to have a look at the templates at File > New in your menu. The 'Employee Schedule' template in particular may give you ideas on how to accomplish what you are trying to do.
SG
If the time stamps are in a recognizable format, you can do a simple subtraction.
A B C
1 [8:57AM] [11:23AM][ 1h ]
=B1 - A1
Thank you kindly, this was just the formula I needed! And that Employee Schedule template looks awesome. I never knew that existed. Thanks again!!!!!
numbers question
