On Tue, 2004-03-09 at 09:33, James&Rosemary Rutherford wrote: > Chris, > It depends on how you entered the times.
Yes. > Excel stores dates and times as a number (whole number for the date, decimal > portion for the time.) Yes. > e.g. 9th March 2004 6.25 am is represented by 38,055.268002778 > The time is a decimal of a day. You will have to convert the times entered > to decimal of a day, then you can tak one from the other (again this will be > decimal of a day which will have to be converted back to minutes or hours) No, you don't have to do anything as evil as that. You can use the timevalue function in excel to do that. Suppose that the start time is in A1 and the end time is in B1. You want to have the duration in C1: Put this into C1: =TIMEVALUE(B1)-TIMEVALUE(A1) If your durations are more than 24 hours, you might have problems with the above. Additional Hint: Displaying formatted times > 24 hours : Format the cell with custom formatting, HHH:MM:SS (note the three 'H') Onno Benschop Connected via Optus B3 at S41°18'23" - E146°49'07" (Holwell, Tas) -- ()/)/)() ..ASCII for Onno.. |>>? ..EBCDIC for Onno.. --- -. -. --- ..Morse for Onno.. Proudly supported by Skipper Trucks, Highway1, Concept AV, Sony Central, Dalcon ITmaze - ABN: 56 178 057 063 - ph: 04 1219 8888 - onno at itmaze dot com dot au
