|
|
#2
04-03-2007, 08:20 AM
|
|||
|
|||
Try this: formate column "A" to a military time format. Then place the following values or fomulas in the noted cells:
A1: 00:30 this is the lunch you want to subtract out A2: 08:00 this is start of the day A3: 17:00 this is the end of the day A4: =sum((A3-A2)-A1) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Anyway to determine time/date of text creation? | pureride | Word | 1 | 01-05-2010 02:09 PM |
 How to get cells to calculate time?
|
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
| Time stamps and postponing messages. | thundermocos | Outlook | 0 | 10-29-2006 06:04 AM |
| Propose new time issue | cisgoro | Outlook | 0 | 08-10-2006 10:59 AM |
|
Enter Number on any sheet one time only.
|
paulrm906 | Excel | 1 | 04-28-2006 07:35 AM |
Threaded Mode