View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi
 
Posts: n/a
Default Formatting a cell to calculate time.

Custom formatting: [m]

Regards,
Stefi


€˛Lee€¯ ezt Ć*rta:

I have a time sheet that has a group of cells that calculate vacation or sick
time earned and used. How do I format a cell so that 0:45 shown in the cell
means 45 minutes and not 12:45 am.
--
Lee Davenport