Convert Time to value (Rupees)

This query is : Resolved

Jitendra Rathod (Querist)
Follow

29 April 2010 Dear All,

PLease help in this regard -

I want to convet time (1:20 AM) to Value ie Rs 1.20

Its Urgent please Help!!!!!!!!!!!!

Do the needful

Regards
RJ

CA CS CIMA Prakash Somani

CA CS CIMA Prakash Somani (Expert)
Follow

29 April 2010 I have one formula by which you can convert value to time but not from time to value. check this excel file >>> https://www.caclubindia.com/forum/convert-date-to-value-80699.asp <<<

CA Shiv

CA Shiv (Expert)
Follow

29 April 2010 hey can you tell me what it is about...i didnt understand the formula

Upgrade to CAclubindia Pro. Subscribe Now!

CA CS CIMA Prakash Somani

CA CS CIMA Prakash Somani (Expert)
Follow

30 April 2010 he wants to convert the time into Rs value say time is 1:20 PM then Rs shoud be Rs 1.20 :) check the link i have provided and follow the intructions given there.