I'm logging my work hours, and I want to enter my start time and end time on a spread sheet to keep track of my hours.
oops' I thought this was an AI agent that would answer my question, maybe there is some Real Intelligence that can help me. LOL!
iPad Air 3
Yep, real people here :)
I suspect there's a lot more to your ask than your post implies, but at its simplest level, you can create a table with date and time fields. Numbers than then use those fields in calculations, for example:
Here you can see the 'Hours' cell D2 is simply a calculation that subtracts Start time (B2) from End Time (C2) to give the difference.
Now, there may be more complications such as break times, vacation days, etc., but you didn't ask about those :)
Yep, real people here :)
I suspect there's a lot more to your ask than your post implies, but at its simplest level, you can create a table with date and time fields. Numbers than then use those fields in calculations, for example:
Here you can see the 'Hours' cell D2 is simply a calculation that subtracts Start time (B2) from End Time (C2) to give the difference.
Now, there may be more complications such as break times, vacation days, etc., but you didn't ask about those :)
Also check out the built-in 'Employee Schedule' template. The table at the lower right provides a working example.
SG
logging hours for a work time sheet
