| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding time AM/PM
How do a create a text formula that shows 13:10 as 1:10?
I don't want the PM in the text formula. When leave out the AM/PM it shows as 13:10 and I don't want that. Text(A1, "h:mm") shows 13:10 Text(A1, "h:mm AM/PM") shows 1:10 PM I just wat 1:10.... no PM! Thanks, Joe |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding time AM/PM
try this:
=LEFT(TEXT(G5,"hhh:mm am/pm"),5) "JoeyZaZa" wrote: How do a create a text formula that shows 13:10 as 1:10? I don't want the PM in the text formula. When leave out the AM/PM it shows as 13:10 and I don't want that. Text(A1, "h:mm") shows 13:10 Text(A1, "h:mm AM/PM") shows 1:10 PM I just wat 1:10.... no PM! Thanks, Joe |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding time AM/PM
Thank you that worked!!!!
"Nikki" wrote: try this: =LEFT(TEXT(G5,"hhh:mm am/pm"),5) "JoeyZaZa" wrote: How do a create a text formula that shows 13:10 as 1:10? I don't want the PM in the text formula. When leave out the AM/PM it shows as 13:10 and I don't want that. Text(A1, "h:mm") shows 13:10 Text(A1, "h:mm AM/PM") shows 1:10 PM I just wat 1:10.... no PM! Thanks, Joe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Time | Excel Worksheet Functions | |||
| Adding time | New Users to Excel | |||
| How do i keep a running balance without adding rows each time? | Excel Worksheet Functions | |||
| Adding time in Excel | Excel Worksheet Functions | |||
| Adding time in Excel | Excel Worksheet Functions | |||
Linear Mode
