M
Mr.B
Hi everyone, I have a problem I can't seem to solve.....Please help.
I have in cell A23 a date and time ---10/19/2008 14:12----
and in cell A24 a date and time----10/20/2008 16:54--- I need this to
calculate the number of hours NOT DAYS and minutes but rond the results to
the nearest half hour........See this is calculating the amount of time that
a product has been out of cold storage so it can't round the time before
calculating.....this is as close as I can come. =TEXT(A24-A23,"[h]:m")
this returns...26:42 and I want it to round to read 26.5
thanks.
I have in cell A23 a date and time ---10/19/2008 14:12----
and in cell A24 a date and time----10/20/2008 16:54--- I need this to
calculate the number of hours NOT DAYS and minutes but rond the results to
the nearest half hour........See this is calculating the amount of time that
a product has been out of cold storage so it can't round the time before
calculating.....this is as close as I can come. =TEXT(A24-A23,"[h]:m")
this returns...26:42 and I want it to round to read 26.5
thanks.