Nancy Comello

Posts: n/a

time card excel sheet

I currently use excel to track over 70 employees but I
need either a formula for the following scenrio.

In 7:45am out 12:00am in 1:25pm out 6:00pm then have a
total of hours in one cell for the whole day.

Right now I am enter the time but in military time.

I did find an excel template to use but the formla is not
right.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How do you set up a data excel sheet that links to a presentation.	Moxy247	Excel Worksheet Functions	0	January 31st 05 06:18 PM
Calculating tvl time in Excel 2000 Rev.9.2720	Brandi	Excel Worksheet Functions	5	January 27th 05 09:15 PM
hyperlink to specific sheet in excel	mango	Excel Worksheet Functions	1	December 9th 04 11:17 AM
Time sheet set up specifically	HT	New Users to Excel	5	December 5th 04 05:56 PM
Adding time in Excel	tahirab	Excel Worksheet Functions	1	November 10th 04 09:47 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us