h:mm time cell format 
Author Message
 h:mm time cell format

is there a way to formate the cell
to show only hour:min
but when inputing  the # 5 it is registered as hour 5 not day five???

I need hours only - no dates

thank you for your time



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. how to transfer mm format to hh:mm format in SQL

2. Time formats (again) From mm.ss to TIME

3. Saved cells with dd/mm/yyyy format, reverts to previous format when opened

4. getting serial time date need yyyy/mm/dd hh:mm:ss

5. Convert Time, hh:mm:ss to hh:mm.00

6. Format now() field as DD/MM/YY HH:MM

7. dd/mm/yyyy to mm/dd/yyyy switch Date format in queries

8. Converting universal date format (#yyyy-mm-dd#) to dd/mm/yy

9. CHANGING THE DEFAULT DATE FORMAT FROM MM-DD-YY to DD-MM-YY

10. Custom Time Format - hh:mm:ss:ff


 
Powered by phpBB® Forum Software © phpBB Group