ExcelBanter

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - time (https://www.excelbanter.com/excel-worksheet-functions/102903-time.html)

Gary

time

how can i convert "22 hours 23 minutes" into 22:23 ?

MartinW

time

Hi Gary,

One way is to use Text to Columns so that in your example
you would have,

A1 B1 C1 D1
22 hours 23 minutes

then in E1 put =A1&":"&C1

Depending on your setup it maybe better to export it to
a blank sheet for the conversion and then import back
to your original.

HTH
Martin

Gary

time

Thanks Martin,

But is it possible to convert 22 Hours 23 Minutes dierctly in to 22:23 ?

"MartinW" wrote in message
...
Hi Gary,

One way is to use Text to Columns so that in your example
you would have,

A1 B1 C1 D1
22 hours 23 minutes

then in E1 put =A1&":"&C1

Depending on your setup it maybe better to export it to
a blank sheet for the conversion and then import back
to your original.

HTH
Martin

Bob Phillips

time

=(LEFT(A11,FIND(" ",A11))+MID(A11,FIND("s ",A11)+2,FIND(" ",A11,FIND("s
",A11)+2)-FIND("s ",A11)-2)/60)/24

and format as hh:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
how can i convert "22 hours 23 minutes" into 22:23 ?

Gary

time

Thanks a ton Bob...u r amazing.

"Bob Phillips" wrote in message
...
=(LEFT(A11,FIND(" ",A11))+MID(A11,FIND("s ",A11)+2,FIND(" ",A11,FIND("s
",A11)+2)-FIND("s ",A11)-2)/60)/24

and format as hh:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
how can i convert "22 hours 23 minutes" into 22:23 ?

All times are GMT +1. The time now is 11:12 PM.