Re: NUMBERS in EXCEL
The times are held as decimals (of a day) and can readily be added and subtracted. It is only the display of those numbers that is formatted for hh:mm:ss
I often have a four or six character text field so you can just enter half past 1 in the afternoon as 1330 then separate this with text functions to get it to 13:30:00 then do your calcs and of course displaying as a 4 or six figure time field is fine. You just want to avoid having to enter the colon when inputting the time.