Home > Programming > Sum of hh:mm in excel.

Sum of hh:mm in excel.


I was digging through the net as i needed to sum a couple of hh:mm data

If the hh:mm is in text then you need to custom format the column to [hh]:mm:ss

Then for sum you do =SUMPRODUCT(–(R2:R22)) (R= Column)

Advertisements
Categories: Programming
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: