How to multiply amount with time

[Shahzad_Ahsan]

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

[MK_QSL · Accepted solution]

=Time#([Time(HH:MM)],'hh:mm')*24*60 * Amount

[amijit_hazarika]

Hi Manish,

This will definitely work. But wanted to know if the below would work too?

=Time#([Time(HH:MM)],'hh:mm')* 3600 *Amount

[MK_QSL]

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.

[Shahzad_Ahsan]

Hi Manish

Thanks for your answer

This is working fine.....