A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

The Sum Of Time



 
 
Thread Tools Display Modes
  #11  
Old June 22nd, 2004, 01:36 PM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default 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  
Old June 22nd, 2004, 11:03 PM
Jezebel
external usenet poster
 
Posts: n/a
Default 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  
Old June 24th, 2004, 11:05 AM
macropod
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.