View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phippsy Phippsy is offline
external usenet poster
 
Posts: 28
Default Adding hours and minutes

Hi

When adding for example overtime I format the cells to be [h]:mm and this
will add beyond 24 hours. However for any value over 24 hours the formula bar
displays a date even though the totals add up with the correct result. How do
I change this to show in date format.