| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert time to text
Sorry, didn't read your post real well...........this one will convert the
..75 to 45 minutes............ =MID(A1,1,FIND(".",A1,1)-1)&" hrs and "&MID(A1,FIND(".",A1,1)+1,99)/100*60&" mins" Vaya con Dios, Chuck, CABGx3 "CLR" wrote: This will work, even if you have more or less than 2 digit hours and minutes =MID(A1,1,FIND(".",A1,1)-1)&" hrs and "&MID(A1,FIND(".",A1,1)+1,99)&" mins" Vaya con Dios, Chuck, CABGx3 "checkQ" wrote: Hi, Does anyone knows a formula to convert the decimal time 47.75 to text in order to read 47 hrs and 45 minutes? Thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Time to a Text | Excel Worksheet Functions | |||
| Convert Text Time to Excel Time | Excel Discussion (Misc queries) | |||
| Convert Text to time value | Excel Discussion (Misc queries) | |||
| How do I convert text to time | Excel Worksheet Functions | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
Threaded Mode
