ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting a Cell as "Time" (https://www.excelbanter.com/excel-discussion-misc-queries/111580-formatting-cell-time.html)

Hi_no_Tori

Formatting a Cell as "Time"
 
Hi...

I'd like to format a cell as "Time". I want to use the 24 hour Timing
system, but When I enter the time: 24:00, I don't want it to apear like
this: 0:00. Is there any possible way to do this.

Bob Phillips

Formatting a Cell as "Time"
 
[h]:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Hi_no_Tori" wrote in message
...
Hi...

I'd like to format a cell as "Time". I want to use the 24 hour Timing
system, but When I enter the time: 24:00, I don't want it to apear like
this: 0:00. Is there any possible way to do this.




Hi_no_Tori

Formatting a Cell as "Time"
 
I tried it. It works. Thank you SO MUCH for your help Bob. (^_^)


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com