Thread: Time Format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Cheekie975 Cheekie975 is offline
external usenet poster
 
Posts: 2
Default Time Format



That's really great thanks and i will definitely use it! However, I could do
with just entering the time so that the user knows when the third party is
due to log in.



"Cheekie975" wrote:

Hi. I want to create a time sheet where a user logs in at a time then logs
out at a time, I want Excel to then calculate the number hours and minutes.

I can't seem to get Excel to just let me enter a time format, it wants to
enter date then time. How can I do this?