Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Calculating TimePosted by Mike Consolo on August 08, 2001 2:40 PM
To Whomever Can Help-
I am trying to calculate the sum of hours that someone might work. I have no problem calculating the hours per day. But when I try and add the total for each of those days together it does not show as 40 or 50, etc.
For example 8 hours on Monday, 8 hours on Tuesday. I would enter 8:00 through 16:00 for each of those days. It would calculate the hours for that day as 8:00(16:00 minus 8:00). However when I add the time for each of those days (8:00 plus 8:00) it does not return the correct value(16).
Can someone tell me how I can use calculations with time.
Re: Calculating TimePosted by Aladin Akyurek on August 08, 2001 2:42 PM
Custom format the cell where you do the summing as:
Re: Calculating TimePosted by Mark W. on August 08, 2001 2:44 PM
Format total as... [h]:mm
Wasted too much time spelling "Pythagorean" : )Posted by Mark W. on August 08, 2001 2:50 PM
Mark and Aladin are correct of course...but in your example 8:00 + 8:00 does come out as 16 (well, 16:00)Posted by Ian on August 08, 2001 3:34 PM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.