time format

Topic

New Reply

Hi
I dont know how I can take a volume (Liters) and divide that by a rate (Liters / min) and format the answer in mm:ss

Anyone know what I need to do to the formula to make this work?

Reply | Quote

Replies

Blueray,

I’m making a couple of assumptions here but if A1 contains liters and B1 contains liters/SECOND then =Time(0,0,A1/B1) will return the right amount of time if you format the cell as MM:SS.

The only way I could get this to work was to use LITERS/SECOND because the TIME function will automatically convert the seconds to the proper number hours/minutes/seconds, but will not convert fractional minutes to seconds for some reason…go figure.

When converting the liters/min to liters/sec I would you suggest you use a round function {=Round(liters-min/60,decimal-places)} where you can control the precision you want in decimal places.

Hope this helps.

RG

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

You need to Convert the answer to a fraction of a Day in order to use a time format

So if A2 contains the Volume and B2 contains the Rate then the formula for the time
to use an mm:ss time format is =((A2/B2)/60)/24

For example If Vol =1000 L and Rate = 45.6 L/min this give 21.93 as a decimal min
which is 21:56 converted to a time where 21.93 min = 0.015229 Days

Reply | Quote

You need to Convert the answer to a fraction of a Day in order to use a time format

So if A2 contains the Volume and B2 contains the Rate then the formula for the time
to use an mm:ss time format is =((A2/B2)/60)/24

For example If Vol =1000 and Rate = 45.6 this give 21.93 as a decimal min
which is 21:56 converted to a time where 21.93 min = 0.015229 Days

WORKS GREAT THANKS!

Reply | Quote