Prev Previous Post   Next Post Next
  #1   Report Post  
Howard
 
Posts: n/a
Default Time as number

I'm working on a time card where employees enter time in, out for lunch, back
in and out for the day. I can do this in a time format and get the total for
the day. However, the manager thinks it's too cumbersome for employees to
type 8:00 AM, 1:00 PM, 2:00 PM, 5:00 PM, for example. Is there a way to do
this using numbers, other than military time, or not having to type AM or PM?

Thanks,
--
Howard
 
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
Need number of Saturdays and number of Sundays between 2 dates Class316 Excel Worksheet Functions 1 June 10th 05 02:47 AM
Time Sheet Calculation Help Needed! sax30 Excel Worksheet Functions 2 April 26th 05 08:08 PM
avoid retype the number more than one time withen acolumn This no. already exist Excel Discussion (Misc queries) 1 April 4th 05 10:25 AM
entering numbers to display a time format Ian Williams/Eazygig Excel Discussion (Misc queries) 1 January 10th 05 11:57 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 03:48 AM.

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

About Us

"It's about Microsoft Excel"