LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 71
Default Calculate time with a break and total hours

I'm trying to calculate length of hours with a break included, but I'm not
sure it's calculating correctly. Here's what I have in military time:

C6=8:00
C7=12:30
C8=13:30
C9=17:25

The formula I have to calculate the total of those hours is:
=C9-C6-1/24+(C9C6)

The break is usually 1 hour, but it can be less or more than 1 hour so I'd
like to change my formula if possible to allow for that variation.

I'm also trying to add the total hours together, but it's not displaying
right. My hours a

8:25 + 8:15 + 8:15 + 8:25 + 8:00 = 6.72

I used the sum function, but I know all that adds up to more than 6.72. :-)

TIA!
Anita
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Calculate Total hours worked during workdays within given shift time. noname Excel Discussion (Misc queries) 2 April 8th 07 06:28 PM
calculating timesheet, time-in/time-out = total hours & minutes, . Steve Lindsay Excel Worksheet Functions 13 November 8th 06 03:45 PM
template or formula for start time -finish time -total hours ple cc New Users to Excel 1 March 27th 06 06:06 PM
How do I calculate total weekly hours for payroll in Excel? laura6201 Excel Discussion (Misc queries) 1 September 14th 05 04:03 PM
How do I calculate total hours by rate of pay? FrankF Excel Worksheet Functions 1 August 16th 05 11:18 PM


All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"