how to calculate working hours using formula

Date

Time In

Time Out

total working  hrs  

01

2022-12-01 06:29:17

2022-12-01 19:01:49

12

7am - 7pm

02

2022-12-02 07:40:43

2022-12-02 20:00:37

12

8am - 8pm

03

2022-12-03 07:47:51

2022-12-03 19:19:02

11

8am to 7pm

04

2022-12-04 07:34:03

2022-12-04 19:45:41

05

2022-12-05 07:44:44

2022-12-05 19:00:19

06

2022-12-06 07:34:50

2022-12-06 19:36:08

07

2022-12-07 07:44:34

2022-12-07 19:02:16

08

N/A

N/A

09

2022-12-09 07:38:25

2022-12-10 08:29:41

10

2022-12-10 18:50:45

2022-12-11 07:35:28

11

2022-12-11 19:00:46

2022-12-12 07:03:46

12

2022-12-12 18:29:37

2022-12-13 07:02:08

13

2022-12-13 18:39:03

2022-12-14 07:02:06

14

N/A

N/A

15

N/A

N/A

16

2022-12-16 07:37:45

2022-12-16 19:02:20

17

2022-12-17 07:47:40

2022-12-18 08:00:07

18

2022-12-18 18:38:28

2022-12-19 07:00:56

19

2022-12-19 18:37:55

2022-12-20 07:02:52

20

2022-12-20 18:55:36

2022-12-21 07:05:14

21

2022-12-21 18:48:20

2022-12-22 07:01:53

Answer
Answer

Hi Karena_d3! Use the function, =ROUNDDOWN((D5-C5)*24,0) https://filestore.community.support.microsoft.com/api/images/8031cf8d-72d0-4b4b-8f48-86f4ff4eacdf?upload=true Kind Regards, Shakiru

Give a helping hand today.....

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 13, 2025 Views 29 Applies to: