View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alojz Alojz is offline
external usenet poster
 
Posts: 161
Default How to type format time in decimal format & calculate

Insert 0:2:30, format either mm:ss or m:ss, for sum cell format [hh]:mm:ss

"Cheyenne" wrote:

I used the CUSTOM function as mm:ss, but it's not working. I want a user to
type in the number of dictated minutes they typed; i.e: 2:30 (2 min. 30 sec)
and have it stay that way after entered. I'm getting results of 12:00?
Also want to add these dictated minutes, and result in H:MM:SS.

HELP? I've tried everything!