time in excel
I have used the TIME function which works well for adding hours/minutes/seconds depending on other formatting, but I find that it will not add total of hours more than 24, i.e, a day, I want to add, say 1:30 to 5645:20 and it does not give me 5646:50 as i might expect, any way of getting Excel to ignore the day and just add hours and minutes in the way you would probably require in a simple log book using the TIME function to more than 24 hours?