Difference in time in two cells

[buzz71023]

Hello all.
I need help finding the difference between two times entered in C19 (start time, formatted to time) and F19 (end time, formatted to time). I need to split the results in two different cells, AI19 (hours) and AL19 (minutes).

There red will be a lot times when the users time is entered in one day and finished in another. For instance, starts at 11:00 pm and ends 1:00 am the next day.

I’ve tried to use the below but I’m not getting the desired results.

=TEXT(C19-F19,”h”)

=HOUR(C19-F19)

 

[Aryatect]

Hi, Try this, columns AI and AL should have general formatting

=HOUR(IF(C19>F19,F19-C19+1,F19-C19))
=MINUTE(IF(C19>F19,F19-C19+1,F19-C19))

 

[Tetra201]

Here is a shorter version to try:

=HOUR(MOD(F19-C19,1))
=MINUTE(MOD(F19-C19,1))

 

[buzz71023]

Thank you both... worked great....