Wednesday, 7 May 2008

Converting minutes from midnight

Jane asked me how to convert "minutes from midnight" into hours and minutes in Excel.

Turns out the TIME() function can do this for you.

Say you have 585 minutes. Use it like this:

=TIME(0, 585, 0)

Then format the cell for time, eg. "h:mm", and you get

"9:45 AM"

Just what the doctor ordered!

Before you ask, no I'm not an Excel expert, but I am pretty good at knowing where to find the answer most of the time.

No comments: