Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
He everyone
I need to calculate 'Result' filed.
Result = Time * Amount
Convert the time in minutes.
Time(HH:MM) | Amount | Result |
---|---|---|
3:45 | 14.2 | 3195 |
1:30 | 3.65 | 328.5 |
0:35 | 4.25 | 148.75 |
0:56 | 12.59 | 705.04 |
=Time#([Time(HH:MM)],'hh:mm')*24*60 * Amount
=Time#([Time(HH:MM)],'hh:mm')*24*60 * Amount
Hi Manish,
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.
Hi Manish
Thanks for your answer
This is working fine.....