difference in time

[Jay]

I have 2 times : 16:20 and 01:02
Trying to find the difference in hours between these times.

Used this formula : =(((HOUR(H135-I135)-24)*60)+MINUTE(H135-I135))/60

However the difference comes up as a negetive numbe. I understand the 24
hour clock peice and why this is happening.

Is there a way to return the correct number as a positive value of hours
between these 2 times?

 

[Bruce Sinclair]

I have 2 times : 16:20 and 01:02
Trying to find the difference in hours between these times.

Used this formula : =(((HOUR(H135-I135)-24)*60)+MINUTE(H135-I135))/60

However the difference comes up as a negetive numbe. I understand the 24
hour clock peice and why this is happening.

Is there a way to return the correct number as a positive value of hours
between these 2 times?

Suggest using dates/times. I suspect the negative number you are getting is
right (as you are subtracting 16:20 from 02:02 ?) ... but what you are
trying to do is get the hours from 16:20 to 01:02 *the next day* ??
Remember that standard dates and times are just numbers in XL ... it's all
in the formatting as to what you see.