How to type format time in decimal format & calculate
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! |
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! |
All times are GMT +1. The time now is 11:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com