trying to create a formula that will display the total number of hours that the employees are on break based on the current time

[Anonymoose2435]

I am trying to create a formula so that if the current time is GREATER than Start of break time, it'll show the difference between them in hh:mm:ss, if not it'll show 00:00:00. But everything is being calculated. Am i missing something? Current time as of this post is 3:58 PM

Module 5 Case Study(1).xlsx
	A	B	C	D
4		IT SUPPORT / HELPDESK	Start of break	Total hours on break
5	1	person1	11:55:00 AM	03:54:24
6	2	person2	2:20:00 PM	01:29:24
7	3	person3	9:34:00 AM	06:15:24
8	4	person4	8:56:00 PM	18:53:24
9	5	person5	7:54:00 PM	19:55:24
10	6	person6	12:03:00 PM	03:46:24
11	7	person7	1:17:00 AM	14:32:24
12	8	person8	4:12:00 AM	11:37:24
13	9	person9	5:45:00 AM	10:04:24
14	10	person10	6:35:00 AM	09:14:24
15	11	person11	10:08:00 AM	05:41:24
16	12	person12	2:07:00 PM	01:42:24
17	13	person13	1:15:00 PM	02:34:24
18	14	person14	3:56:00 PM	23:53:24
Task 2

Cell Formulas
Range	Formula
D5:D18	D5	=IF(NOW()>C5,NOW()-C5,TIME(0,0,0))

 

[etaf]

now() also gives the date , integer part of the Date/time
to just get the decimal which is the TIME
NOW()-TRUNC(NOW()

so try
=IF((NOW()-TRUNC(NOW()))>C2,(NOW()-TRUNC(NOW()))-C2,TIME(0,0,0))

Book9
	B	C	D	E	F	G
1	IT SUPPORT / HELPDESK	Start of break	Total hours on break	Now	TIME general	Time General
2	person1	11:55:00	00:00:00	2/11/22 8:20	0.347376389	0.496527778
3	person2	14:20:00	00:00:00		0.347376389	0.597222222
4	person3	09:34:00	00:00:00		0.347376389	0.398611111
5	person4	20:56:00	00:00:00			0.872222222
6	person5	19:54:00	00:00:00			0.829166667
7	person6	12:03:00	00:00:00			0.502083333
8	person7	01:17:00	07:03:13			0.053472222
9	person8	04:12:00	04:08:13			0.175
10	person9	05:45:00	02:35:13			0.239583333
11	person10	06:35:00	01:45:13			0.274305556
12	person11	10:08:00	00:00:00			0.422222222
13	person12	14:07:00	00:00:00			0.588194444
14	person13	13:15:00	00:00:00			0.552083333
15	person14	15:56:00	00:00:00			0.663888889
Sheet1

Cell Formulas
Range	Formula
E2	E2	=NOW()
F2:F4	F2	=NOW()-TRUNC(NOW())
D2:D15	D2	=IF((NOW()-TRUNC(NOW()))>C2,(NOW()-TRUNC(NOW()))-C2,TIME(0,0,0))

 

[Anonymoose2435]

now() also gives the date , integer part of the Date/time
to just get the decimal which is the TIME
NOW()-TRUNC(NOW()

so try
=IF((NOW()-TRUNC(NOW()))>C2,(NOW()-TRUNC(NOW()))-C2,TIME(0,0,0))

Book9
	B	C	D	E	F	G
1	IT SUPPORT / HELPDESK	Start of break	Total hours on break	Now	TIME general	Time General
2	person1	11:55:00	00:00:00	2/11/22 8:20	0.347376389	0.496527778
3	person2	14:20:00	00:00:00		0.347376389	0.597222222
4	person3	09:34:00	00:00:00		0.347376389	0.398611111
5	person4	20:56:00	00:00:00			0.872222222
6	person5	19:54:00	00:00:00			0.829166667
7	person6	12:03:00	00:00:00			0.502083333
8	person7	01:17:00	07:03:13			0.053472222
9	person8	04:12:00	04:08:13			0.175
10	person9	05:45:00	02:35:13			0.239583333
11	person10	06:35:00	01:45:13			0.274305556
12	person11	10:08:00	00:00:00			0.422222222
13	person12	14:07:00	00:00:00			0.588194444
14	person13	13:15:00	00:00:00			0.552083333
15	person14	15:56:00	00:00:00			0.663888889
Sheet1

Cell Formulas
Range	Formula
E2	E2	=NOW()
F2:F4	F2	=NOW()-TRUNC(NOW())
D2:D15	D2	=IF((NOW()-TRUNC(NOW()))>C2,(NOW()-TRUNC(NOW()))-C2,TIME(0,0,0))

This worked! thank you!

 

[etaf]

you are welcome