Converting Minutes to Seconds

  • Thread starter Thread starter penroma
  • Start date Start date
P

penroma

I have a list of times formated in minutes and hundredths of minutes
for example 7360.50 and 8622.42. I need to be able to covert thes
numbers to seconds. I am sure this is an easy formula, I just don'
have the time to think it through.

Thanks.

PS. Just to clarify 7360.50 is the same as 2:40:30 and 8622.42 i
23:42:25
 
I think you got it wrong, haw can 7360.50 minutes be only 2:40:30
You need to use [hh]:mm:ss as format to get all hours, otherwise get up to
24 hours
However if you want it in seconds just multiply with 60

=7360.50*60

is 441630 seconds

if you want time divide by 1440 and format as [ss]

7360.50/1440
 
Thank you Peo. I realized my mistake and was coming to back to edit m
post when I saw your response. Thanks
 
Back
Top