| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Time to a Text
Hi,
I need help with a formula. I'm trying to convert a time to text as in the example below. Example: A1= 5:16 PM B1= 1716 Thanks for any help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert Time to a Text
=TEXT(A1,"hhmm")
"CJ" wrote: Hi, I need help with a formula. I'm trying to convert a time to text as in the example below. Example: A1= 5:16 PM B1= 1716 Thanks for any help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert Time to a Text
One approach:
=TEXT(HOUR(A1,"00") & TEXT(MINUTE(A1),"00") HTH, "CJ" wrote in message ... Hi, I need help with a formula. I'm trying to convert a time to text as in the example below. Example: A1= 5:16 PM B1= 1716 Thanks for any help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert Time to a Text
Thank you.
"Teethless mama" wrote: =TEXT(A1,"hhmm") "CJ" wrote: Hi, I need help with a formula. I'm trying to convert a time to text as in the example below. Example: A1= 5:16 PM B1= 1716 Thanks for any help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Convert Text Time to Time | Excel Discussion (Misc queries) | |||
Linear Mode
