How to format time in decimal format & calculate time
 

I used the CUSTOM function as [mm:ss], but it's not working as I thought that
it would. What I want is a user to type in the number of dictated minutes
they typed for a job; i.e: 2:30 (2 min. 30 sec) and have it stay in that
format as decimal after entered. However, I'm getting results of 12:00 for
that example when using the format stated above? I also want to add these
dictated minutes and have the result calculated in H:MM:SS. HELP? I've tried
everything!

How to format time in decimal format & calculate time
 

Even though the display for mat is mm:ss, you still need to enter data
hh:mm:ss.

So instead of

12:25

use

0:12:25

when you type
--
Gary''s Student - gsnu200832


"Cheyenne" wrote:

I used the CUSTOM function as [mm:ss], but it's not working as I thought that
it would. What I want is a user to type in the number of dictated minutes
they typed for a job; i.e: 2:30 (2 min. 30 sec) and have it stay in that
format as decimal after entered. However, I'm getting results of 12:00 for
that example when using the format stated above? I also want to add these
dictated minutes and have the result calculated in H:MM:SS. HELP? I've tried
everything!

How to format time in decimal format & calculate time
 

Hi Gary,

Thanks so much for the info. Is there anyway that the user can just press
the . (decimal) key when entering information, without them having to stop
and find the colon (:) key when inputting the numbers, WITHOUT me having to
do some sort of formulation in another field to make this happen, as these
cells are not underneath or next to each other, but various places throughout
the spreadsheet.
Thanks,
Cheyenne

"Gary''s Student" wrote:

Even though the display for mat is mm:ss, you still need to enter data
hh:mm:ss.

So instead of

12:25

use

0:12:25

when you type
--
Gary''s Student - gsnu200832


"Cheyenne" wrote:

I used the CUSTOM function as [mm:ss], but it's not working as I thought that
it would. What I want is a user to type in the number of dictated minutes
they typed for a job; i.e: 2:30 (2 min. 30 sec) and have it stay in that
format as decimal after entered. However, I'm getting results of 12:00 for
that example when using the format stated above? I also want to add these
dictated minutes and have the result calculated in H:MM:SS. HELP? I've tried
everything!

How to format time in decimal format & calculate time
 

Hi Gary,

Thanks so much for the info. Is there anyway that the user can just press
the . (decimal) key when entering information, without them having to stop
and find the colon (:) key when inputting the numbers, WITHOUT me having to
do some sort of formulation in another field to make this happen, as these
cells are not underneath or next to each other, but various places throughout
the spreadsheet.
Thanks,
Cheyenne

"Gary''s Student" wrote:

Even though the display for mat is mm:ss, you still need to enter data
hh:mm:ss.

So instead of

12:25

use

0:12:25

when you type
--
Gary''s Student - gsnu200832


"Cheyenne" wrote:

I used the CUSTOM function as [mm:ss], but it's not working as I thought that
it would. What I want is a user to type in the number of dictated minutes
they typed for a job; i.e: 2:30 (2 min. 30 sec) and have it stay in that
format as decimal after entered. However, I'm getting results of 12:00 for
that example when using the format stated above? I also want to add these
dictated minutes and have the result calculated in H:MM:SS. HELP? I've tried
everything!

How to format time in decimal format & calculate time
 

Hi Gary,

Thanks so much for the info. Is there anyway that the user can just press
the . (decimal) key when entering information, without them having to stop
and find the colon (:) key when inputting the numbers, WITHOUT me having to
do some sort of formulation in another field to make this happen, as these
cells are not underneath or next to each other, but various places throughout
the spreadsheet.
Thanks,
Cheyenne

"Gary''s Student" wrote:

Even though the display for mat is mm:ss, you still need to enter data
hh:mm:ss.

So instead of

12:25

use

0:12:25

when you type
--
Gary''s Student - gsnu200832


"Cheyenne" wrote:

I used the CUSTOM function as [mm:ss], but it's not working as I thought that
it would. What I want is a user to type in the number of dictated minutes
they typed for a job; i.e: 2:30 (2 min. 30 sec) and have it stay in that
format as decimal after entered. However, I'm getting results of 12:00 for
that example when using the format stated above? I also want to add these
dictated minutes and have the result calculated in H:MM:SS. HELP? I've tried
everything!