Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default How to type format time in decimal format & calculate time

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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default How to type format time in decimal format & calculate time

Unfortunately, Excel interprets 2:30 as 2 hours and 30 minutes, not 2
minutes and 30 seconds. Your choices a
1. Enter 0:2:30
2. Enter 2:30.0
3. Divide 2:30 by 60 to convert to minutes and seconds
4. Write a macro which converts the data entered.
5. Lie to Excel. If you always use minutes and seconds, enter as 2:30, and
format as [h]:mm. All your calculations will still work.

Regards,
Fred.

"Cheyenne" wrote in message
...
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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding time in 24 hour format to produce hours in decimal format Hercdriver Excel Worksheet Functions 11 December 29th 09 03:06 AM
How to type format time in decimal format & calculate Cheyenne Excel Discussion (Misc queries) 1 February 13th 09 12:54 AM
Decimal to Time Format. GEM Excel Worksheet Functions 6 July 30th 08 10:56 PM
Format time as decimal? Roberta Excel Discussion (Misc queries) 2 March 2nd 07 07:29 PM
Adding new 'Type' to Format->Number->Time->Type Chip Pearson Excel Discussion (Misc queries) 5 September 26th 05 08:45 PM


All times are GMT +1. The time now is 11:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"