convert decimal to time
 

i want to know how to change the decimal to time format.

eg: when i enter the time as 9.30 i want that to be changed as 9:30 and
also when i enter the time as 1.38 to be changed as 13:38

Thnak you

convert decimal to time
 

=time(INT(A1),MOD(A1,1)*100,0)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"ganga" wrote in message
...
i want to know how to change the decimal to time format.

eg: when i enter the time as 9.30 i want that to be changed as 9:30 and
also when i enter the time as 1.38 to be changed as 13:38

Thnak you

convert decimal to time
 

Hi

In order to deal with the second part of your request, you would need to
modify Bob's formula with something like

=TIME(INT(A1)+12*(INT(A1)<8),MOD(A1,1)*100,0)

Any times which are less than 8, would have 12 hours added to make them
PM instead of AM.
Change the 8 to whatever value suits your purpose.

--
Regards

Roger Govier


"Bob Phillips" wrote in message
...
=time(INT(A1),MOD(A1,1)*100,0)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"ganga" wrote in message
...
i want to know how to change the decimal to time format.

eg: when i enter the time as 9.30 i want that to be changed as 9:30
and
also when i enter the time as 1.38 to be changed as 13:38

Thnak you

convert decimal to time
 

Thank you very match....

"Roger Govier" wrote:

Hi

In order to deal with the second part of your request, you would need to
modify Bob's formula with something like

=TIME(INT(A1)+12*(INT(A1)<8),MOD(A1,1)*100,0)

Any times which are less than 8, would have 12 hours added to make them
PM instead of AM.
Change the 8 to whatever value suits your purpose.

--
Regards

Roger Govier


"Bob Phillips" wrote in message
...
=time(INT(A1),MOD(A1,1)*100,0)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"ganga" wrote in message
...
i want to know how to change the decimal to time format.

eg: when i enter the time as 9.30 i want that to be changed as 9:30
and
also when i enter the time as 1.38 to be changed as 13:38

Thnak you