LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default convert into time format

hi
I want to make a simple timetabel for my employees. Instead of time format
mm:ss I would like them just to type 1000 as in 10:00. I cannot find the
right way, and do not have expert skills in Excel. pls. help.
Henrik.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert time in xxxx format to xx:xx jenn Excel Discussion (Misc queries) 8 March 6th 08 07:39 AM
convert 7h 40.80n into time format Todd Excel Worksheet Functions 1 August 9th 06 01:33 AM
convert time imported as text to time format for calculations batfish Excel Worksheet Functions 3 October 27th 05 11:24 PM
convert number to time format? JLHORMAN Excel Discussion (Misc queries) 1 May 26th 05 06:38 PM
Help Q: Entering 7 p time format, does not convert to 19:00 Frank Kabel Excel Discussion (Misc queries) 0 December 7th 04 07:20 AM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"