Calculating time using minutes.

  • Thread starter Thread starter computerkiller
  • Start date Start date
C

computerkiller

I have created an invoice to record the minutes I work on a job but can not
figure out how to sum the total time I want the minutes in the format hours
and half hours, ie 1.5 hours. Can some one tell me how to do this. Thank you.
 
How are the times being entered into the invoice? In what format? As
ordinary text? Into FormFields?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
 
I am going to input them as 15 min intervals. I do not know what you mean as
format, unless you mean time = .15. I guess that would be ordinary text. I am
not using FormFields. This is just as a column with the time in it. (Note
this is in Word.)

Thank you for responding. DB.

_______________
 
Assuming that you are entering the times as minutes (15, 30, 45 etc.) into
the cells of a column in a table, in the cell where you want the total to
appear, you can used the formula

{ = SUM(ABOVE)/60 }

If you are using .15 for 15 minutes, then you would use

{ = SUM(ABOVE)/.6

However, using 1.5 for one hour and 30 minutes, will not give you the
correct result. You would have to use .90 for that; two hours would be 1.2
etc.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
 
Back
Top