Display Hours & Minutes (Time) as Minutes

Lee Wood

Good afternoon all,

I have a column that displays time taken to do a task in this format:

H:MM

I would like to have a column at the end of my sheet that displays this information in minute format. Please can you help with the formatting.

Thank you

Paul Newcome

You would need somethign like this:

=(VALUE(LEFT([TIme Column]@row, FIND(":", [Time Column]@row) - 1)) * 60) + VALUE(RIGHT([Time Column]@row, 2))