ExcelBanter - converting time values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - converting time values (https://www.excelbanter.com/excel-discussion-misc-queries/63481-converting-time-values.html)

redtool_man

converting time values

how can i convert a time value, eg 1:30:34 to just minutes, eg 90minutes 34
seconds.

Stefi

converting time values

Apply custom cell format [mm]:ss

Regards,
Stefi

€žredtool_man€ ezt Ã*rta:

how can i convert a time value, eg 1:30:34 to just minutes, eg 90minutes 34
seconds.

redtool_man

converting time values

Thanks Steffi, you're a star, I'll buy you a drink when I see you.

"Stefi" wrote:

Apply custom cell format [mm]:ss

Regards,
Stefi

€žredtool_man€ ezt Ã*rta:

how can i convert a time value, eg 1:30:34 to just minutes, eg 90minutes 34
seconds.

Stefi

converting time values

You are welcome! I like Irish whiskey!

Regards,
Stefi

€žredtool_man€ ezt Ã*rta:

Thanks Steffi, you're a star, I'll buy you a drink when I see you.

"Stefi" wrote:

Apply custom cell format [mm]:ss

Regards,
Stefi

€žredtool_man€ ezt Ã*rta:

how can i convert a time value, eg 1:30:34 to just minutes, eg 90minutes 34
seconds.

All times are GMT +1. The time now is 02:37 PM.