View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xavier xavier is offline
external usenet poster
 
Posts: 21
Default Format the sum cell

hello,

how can i format the cell to display the sum of some time cells like

input
10:00
30:00
20:00

Sum
60:00 <- Problem!!!! it displays only 12:00

i want something like 02:12:00 (2 days 12 hours 00 Min)

thanks

i tryed to use something - hh:mm but it displays