I am using Excel to total hours and minutes on a piece or equipment, a record so we can see which ones are due service when. Easy enough to put in running time but if it is more than 24 hours or the total is greater than this it starts at zero again as it classes it as one day, I want to retain the value in hours which could run intot he hundreds but can't find a way of losing the 24 hour roll over element.
AWould anybody know how to format excel to count in hours and minutes but remove the day element?
Thanks Zak, once you got the message over I tried it and it does just what I was after.
Wee eddie, that would work to get the hours difference but it is a case of the register having hours and minutes put in but with no record of times. I am creating a sheet that is retrospective and so the times would not be available.
This thread is now locked and can not be replied to.