I am trying to put together a fool proof spreadsheet in which it will
automatically compute time. For example; =SUM((B3-B2)) This would be (B3)
06:15 - 15:15 (B2) the result would be 9:00 hours, however when trying to
compute 23:15 - 02:15, using this formula it will not work. I would like to
find out how this can be corrected to compute the right time used. I have
tried the formula =SUM((B3-B2)*24)); this does not help either or even
replacing the *24 with *12. Your assistance would be greatly appreaciated.