I need to calculate 'Result' filed.
Result = Time * Amount
Convert the time in minutes.
=Time#([Time(HH:MM)],'hh:mm')*24*60 * Amount
This will definitely work. But wanted to know if the below would work too?
=Time#([Time(HH:MM)],'hh:mm')* 3600 *Amount
NO... you are 3600 <> 24*60
3600 can be used when you have hour field and you want to convert to second.
I mean when you have Amount per second.
Thanks for your answer
This is working fine.....
Retrieving data ...