Help me to convert time ti decimal value

**rickybhai** · 08-29-2011, 07:45 AM

Dear helper, 1st of all sorry for my bad english as m not so gud in english.

I have a problem, I use the formula and its work well. But my problem is dis:-
eg:- in the cell B3 8:00 and C3 8:30
when i apply formula as given below:
=(HOUR(C3-B3)*60 MINUTE(C3-B3))/60
and the result is 0.50
but i want to get the result as 0.30

plz advice and help me.. Itz argent

**JBeaucaire** · 08-29-2011, 07:56 AM

Just use:

=(C3-B3)

...and format as TIME to get time representation. To be specific, your answer of 0.30 is not a valid result, 0:30 would be.

To get accurate decimal representation, just use

=(C3-B3)*24

...and format that cell as General... result 0.50 which is correct.

EDIT: Resist the urge from yourself or from others to "invent" new math representations. 0.30 / 24 is the decimal representation for about 18 minutes, not 30.

**rickybhai** · 08-29-2011, 08:05 AM

(C3-B3)

the result {0.50} what i got is true, i agree wit dat. I just want to know dat is there any formula which I can get the result as 0.30.

Thanks for your valuable reply.

**Nlex** · 08-29-2011, 08:27 AM

Hi,

As JBeaucaire said, 0.30 is false result.

You can get 0:30, wich is a true result or 0.5 wich is also a true result.

I'm sending you an atached with your values and formula with the 0:30 result.