Converting time into minutes

[Stewman]

Hello,

I have a spreadsheet with hundreds of cells with time in the format as follows: 00:20 which means 20 seconds. My boss nows wants me to convert that 20 seconds into decimal format .3333. Any tips on how to do this easily.

All help appreciated.
Thanks,
Chris

 

[Stewman]

I have figured it out, don't worry about responding.
Thanks,
Chris

 

[ETID]

Look in the help under "convert" for the convert function...

example: =CONVERT(A2,"in","cm").

There should be something like =CONVERT(A2,"sec","min")

Although you may need verify the proper "from" and "to" phrases.

 

[SkipVought]

Why do Dates and Times seem to be so much trouble? faq68-5827

You are converting DAYS to MINUTES.

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]