#1
|
|||
|
|||
Time is killing me!!!
I am struggling with calculating time for our truck drivers. I need a formula that will let me get their total hours and then cut ½ hours for lunch. Try as I might I can’t get anywhere with this. My biggest problem is the small pieces of time they work. They start at 9:45 and finish at 3:15...I’m lost can you help!
Rebecca |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
RE: Time is killing me
Rebecca,
I have a couple of really good examples of this on my computer in work. Tomorrow I will try to post them here for you. My thanks got to the authors of theses examples. |
Thread Tools | |
Display Modes | |
|
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 |