Greg

Posts: n/a

time formula question...

what is the formula for adding time?
For example, I would like my timesheet to automatically add the time I
worked by
adding the time I arrived to the time I left and put the amount of hours in
a total
column. In other words I would like to enter 9:00 AM and 5:00 PM and have
the
total show 8.

thanks in advance
Greg

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
formula question	Pam Coleman	Excel Worksheet Functions	9	April 11th 05 08:51 AM
How do I enter a time formula into a worksheet that determines if.	Lee	Excel Discussion (Misc queries)	1	February 15th 05 02:03 PM
How do I set up a formula on a time sheet to calculate time in 1/.	gschmid	Excel Discussion (Misc queries)	2	January 18th 05 01:48 PM
Best time question	Daniel Bonallack	Excel Worksheet Functions	2	December 10th 04 11:37 PM
Time / Formula to look at time difference	carl	Excel Worksheet Functions	5	November 8th 04 06:59 PM

All times are GMT +1. The time now is 04:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us