Calculation of time worked

I work on both an iPad and a Mac and my worksheet, stored in iCloud, is accessed on both devices


I should like to create a simple Numbers worksheet where I enter in the first column the time I started a task and in the next column the time I ended it, and for the result, in hours and minutes, to show in the third column. Sometimes the task will start on the evening of one day and end the following day.


Any assistance would be greatly appreciated as to how best to format each column and what formula should be used in the third column to achieve the desired result.


Many thanks.

Posted on Aug 9, 2022 5:23 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 9, 2022 6:03 AM

assuming you type

the DATE AND TIME when you start a task in column A and

the DATE AND TIME when you stop the task in column B


then you should be able to use the formula

=B-A


to get a duration


entering the DATE and TIME is essential



C2=B2−A2


select cell C2, then type (or copy and paste from here) the formula:

=B2−A2


if you want to fill this formula down,

select cell C2, copy

select cells C2 thru the end of column C (or as needed), paste


4 replies
Question marked as Top-ranking reply

Aug 9, 2022 6:03 AM in response to ErnestineGreen

assuming you type

the DATE AND TIME when you start a task in column A and

the DATE AND TIME when you stop the task in column B


then you should be able to use the formula

=B-A


to get a duration


entering the DATE and TIME is essential



C2=B2−A2


select cell C2, then type (or copy and paste from here) the formula:

=B2−A2


if you want to fill this formula down,

select cell C2, copy

select cells C2 thru the end of column C (or as needed), paste


This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Calculation of time worked

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.