| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time format 1500 become 15:00
Pls help me.
I want to tape 1500 on A1 and A1 edit 15:00 Thanks for your answer |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time format 1500 become 15:00
Oh Yes, thanks so much.
"מיכאל (מיקי) אבידן" wrote: Use 'Custom Format': ##\:## Micky "tran1728" wrote: Pls help me. I want to tape 1500 on A1 and A1 edit 15:00 Thanks for your answer |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time format 1500 become 15:00
Dear Micky, thanks again,
I have a other question, si possible for Macro, The cursor go directy to the last row+1 of column A thanks for your reply "מיכאל (מיקי) אבידן" wrote: And using this in an adjacent cell will also allow calculations. In cell A1 Type: 1234 In Cell B1 type: =TEXT(A1,"00\:00") Micky "מיכאל (מיקי) אבידן" wrote: Use 'Custom Format': ##\:## Micky "tran1728" wrote: Pls help me. I want to tape 1500 on A1 and A1 edit 15:00 Thanks for your answer |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time format 1500 become 15:00
Try
Cells(Rows.Count, "A").End(xlUp).offset(1).select -- Jacob (MVP - Excel) "tran1728" wrote: Dear Micky, thanks again, I have a other question, si possible for Macro, The cursor go directy to the last row+1 of column A thanks for your reply "מיכאל (מיקי) אבידן" wrote: And using this in an adjacent cell will also allow calculations. In cell A1 Type: 1234 In Cell B1 type: =TEXT(A1,"00\:00") Micky "מיכאל (מיקי) אבידן" wrote: Use 'Custom Format': ##\:## Micky "tran1728" wrote: Pls help me. I want to tape 1500 on A1 and A1 edit 15:00 Thanks for your answer |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time format 1500 become 15:00
Superbe, thanks.
"Jacob Skaria" wrote: Try Cells(Rows.Count, "A").End(xlUp).offset(1).select -- Jacob (MVP - Excel) "tran1728" wrote: Dear Micky, thanks again, I have a other question, si possible for Macro, The cursor go directy to the last row+1 of column A thanks for your reply "מיכאל (מיקי) אבידן" wrote: And using this in an adjacent cell will also allow calculations. In cell A1 Type: 1234 In Cell B1 type: =TEXT(A1,"00\:00") Micky "מיכאל (מיקי) אבידן" wrote: Use 'Custom Format': ##\:## Micky "tran1728" wrote: Pls help me. I want to tape 1500 on A1 and A1 edit 15:00 Thanks for your answer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| I wana prepare a pay roll of employee of 1500 | Excel Discussion (Misc queries) | |||
| 'Average' Function on 1500 lines | New Users to Excel | |||
Linear Mode
