How to type format time in decimal format & calculate

C

Cheyenne

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type format time in decimal format & calculate time 1
How to format time in decimal format & calculate time 4
How to format time in decimal format & calculate time 1
Excel 2003 - Time Formats 5
Round time to nearest 15 minutes in decimal format 4
mm:ss keeps changing to a date format 6
Creating uniform time format from multiple formats 1
Custom format mm:ss 3

Top