calculate minutes to seconds

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

So sorry to post this - but my brain is just not working!! I have a field
called FileLength where users enter a value such as 1.36 which in actual fact
means 96 seconds. I would like the 96 seconds to be caluclated in text box
on the form - lets call the text box FLSeconds. I know that I cant do
1.36*60!!!

Any help?
 
Mybe there is a better way, but you can use this

=int(FieldName) * 60 + (FieldName - Int(FieldName)) * 100
 
Bob,

Thank you this worked!!!
--
Cheers


Bob Miller said:
I'm assuming that FileLength is a number field. FLSeconds would be:
=(Int([FileLength])*60)+(([FileLength]-Int([FileLength]))*100)
Be sure to format it as Fixed with 0 decimal places.
There may be cleaner ways but this works,
Bob said:
Hi all

So sorry to post this - but my brain is just not working!! I have a
field
called FileLength where users enter a value such as 1.36 which in
actual fact
means 96 seconds. I would like the 96 seconds to be caluclated in text
box
on the form - lets call the text box FLSeconds. I know that I cant do
1.36*60!!!

Any help?
Click to expand...
Click to expand...
 
Back
Top