Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time
how can i convert "22 hours 23 minutes" into 22:23 ?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
Hot key for time? | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Entering Times | Excel Discussion (Misc queries) |