summation of time

M

mark

hi,
i need a way to calculation the summation of time in a repeating table:
EX:1houre 2 min +3 houre 52 minutes=?????

anyone can help
 
S

S.Y.M. Wong-A-Ton

Multiply the hours by 60 to get everything in minutes, do the summation, and
then if you need to display hours, divide by 60.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Skipping the first row in a repeated header 0
Removing a repeated words 0
How to save random numbers? 3
Template with fields and premade texts.. 0
Countdown macro - display settings 2
Summing time durations 2
Repeating a row other than the 1st row as the header row in a table from next page 1
Sum of values in column A based on 0/1 of column B 2

Top