Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-02-2007, 07:29 AM
rhale1122 rhale1122 is offline
Novice
Time is killing me!!!
 
Join Date: Apr 2007
Posts: 1
rhale1122
Default 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
Reply With Quote
  #2  
Old 04-03-2007, 08:20 AM
wheedav1 wheedav1 is offline
Novice
 
Join Date: Apr 2007
Location: WA
Posts: 1
wheedav1
Default

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)
Reply With Quote
  #3  
Old 12-02-2008, 09:39 PM
CharlesWilliams CharlesWilliams is offline Time is killing me!!! Windows 10 Time is killing me!!! Office 2019
Novice
 
Join Date: Nov 2008
Posts: 3
CharlesWilliams is on a distinguished road
Default 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.
Reply With Quote
Reply

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
Time is killing me!!! 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
Time is killing me!!! Enter Number on any sheet one time only. paulrm906 Excel 1 04-28-2006 07:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft