If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
The Sum Of Time
I'll have to chew on that a bit. I don't round any more because my hourly
rate is evenly divisible by 60. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Pat Garard" apgarardATbigpondPERIODnetPERIODau wrote in message ... Ok Suzanne, Bear in mind that the basic time integer is Days. When you've set it up, you'll use the =SUM(...) to give you the Total Hours in "[h]:mm" format in (say) cell J20. To calculate the Bill, use the SAME SUM(...): = J20*24(hours)*rate($/hour) (= $Chargable) You can round J20 to the nearest 15min (say) using =INT(SUM(...) * 24 * 4 +0.5) / 4 / 24 | | | | | | Days | QtrHrs | Hrs | Hrs NrstQtr Days (again) to the nearest 15min (all the while DISPLAYING as [h]:mm). Alternatively format J20 as a Number (2 dec places), enter "decimal minutes." into K20, and (in J12) use: =INT(SUM(...) * 24 * 4 +0.5) / 4 | | | | | Days | QtrHrs | Hrs (to the nearest 0.25 hr) Hrs NrstQtr All the best now - Have Fun!! -- Regards, Pat Garard Australia ______________________________________ |
#12
|
|||
|
|||
The Sum Of Time
Time values are precise to 5 decimal places -- ie one millisecond -- so that
shouldn't be an issue. "Suzanne S. Barnhill" wrote in message ... I'll have to chew on that a bit. I don't round any more because my hourly rate is evenly divisible by 60. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Pat Garard" apgarardATbigpondPERIODnetPERIODau wrote in message ... Ok Suzanne, Bear in mind that the basic time integer is Days. When you've set it up, you'll use the =SUM(...) to give you the Total Hours in "[h]:mm" format in (say) cell J20. To calculate the Bill, use the SAME SUM(...): = J20*24(hours)*rate($/hour) (= $Chargable) You can round J20 to the nearest 15min (say) using =INT(SUM(...) * 24 * 4 +0.5) / 4 / 24 | | | | | | Days | QtrHrs | Hrs | Hrs NrstQtr Days (again) to the nearest 15min (all the while DISPLAYING as [h]:mm). Alternatively format J20 as a Number (2 dec places), enter "decimal minutes." into K20, and (in J12) use: =INT(SUM(...) * 24 * 4 +0.5) / 4 | | | | | Days | QtrHrs | Hrs (to the nearest 0.25 hr) Hrs NrstQtr All the best now - Have Fun!! -- Regards, Pat Garard Australia ______________________________________ |
#13
|
|||
|
|||
The Sum Of Time
Hi Taz Man,
You can indeed add times in Word, it just gets very complex. For an idea of what would be required to add just two times, see the topics on time calculations in the attachment at: http://www.wopr.com/cgi-bin/w3t/show...&Number=249902 (url all one line) Cheers "The Taz Man" wrote in message ... In my table I have a column of timings which I want to total in hours, minutes & seconds. Does anyone know how I can do this using a formula or I'm I going about this the wrong way? Does the timings in the column need to be formatted in a special way so that WORD recognize them as timings? Thanks for you time in reading this query. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.710 / Virus Database: 466 - Release Date: 23/06/2004 |
|
Thread Tools | |
Display Modes | |
|
|