Time Calculation Problem

[Sufiyan97]

Calculation doesn't look right

FAC-Visits-6.11-6.17.21-Hours.xlsx
	I	J
6	7:11:00	600:30:00
7	1:40:00
8	5:12:00
9	6:51:00
10	4:42:00
11	10:54:00
12	12:00:00
CareWatch

Cell Formulas
Range	Formula
I6:I12	I6	=IF(ISBLANK(F6),"No Check out",IF(H6<F6,(H6+24)-F6,H6-F6))
J6	J6	=SUM(I6:I12)

 

[Fluff]

Depends on what the exact values in I6:I12 are.
Try formatting them as [h]:mm:ss

 

[Sufiyan97]

Hello Fluff, Formatted as [h]:mm:ss

how to get it right?

FAC-Visits-6.11-6.17.21-Hours.xlsx
	F	G	H	I
7	12:49:00	6/16/21	14:29:00	1:40:00
8	13:57:00	6/15/21	19:09:00	5:12:00
9	12:32:00	6/14/21	19:23:00	6:51:00
10	15:08:00	6/13/21	19:50:00	4:42:00
11	12:22:00	6/12/21	23:16:00	10:54:00
12	15:58:00	6/12/21	3:58:00	564:00:00
CareWatch

Cell Formulas
Range	Formula
I7:I12	I7	=IF(ISBLANK(F7),"No Check out",IF(H7<F7,(H7+24)-F7,H7-F7))

 

[Fluff]

The +24 should be +1

 

[Sufiyan97]

The +24 should be +1

Ok got it
so what it is it adding? 24 hours or days.

 

[Fluff]

24 days

 

[Sufiyan97]

The +24 should be +1

Thank you very much Fluff it works..

24 days

Ok Thank you

 

[Fluff]

You're welcome & thanks for the feedback.