MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Working in Time

Posted by Brian Wilson on February 19, 2001 12:17 AM

I am setting up a spreadsheet that calculates plant efficiencies. I would like to find a way to add or subtract in Hours and Minutes that gives me a result in hours and minutes and not a point in time. The spreadsheet works ok most of the time but it gets unpredictable when working around 12:00 hours and 00:00 hours, basically because Excel thinks I am working in real time and it gets confused at the transitions from am to pm and pm to am. Can you give me a couple of clues here please?



Posted by Dave Hawley on February 19, 2001 1:05 AM

Hi Brian

Format your cell that will be housing the added/subtracted hours as Format>Cells>Number|Custom: [h]:mm

This will allow for times greater than 24 hours.


OzGrid Business Applications