our company works with iso standards.we need to put in our start time and
finished time ( in 24 hour format ). The shifts start at 06:00 and finishes
at 18:00, but this is when the next shift starts 18:00 to 06:00.

A1=Start Time B1= Finished Time C1 = Actual Time
23:00 01:24 2.4

iso standards 1 unit = 6 minutes

i found one thread that show this formulaa which works up to midnight but
after that it don't

=Round((A1-B1)*24,2)

any help on this matter or any direction is greatly appreciated and Thank
You in advance.