ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

2 Q & A posts tagged with HOUR

Sat
Apr 25
2009

I want to add no. of hours spreaded in multiple rows in excel, can any body tell me the formula for the same?


Answer

If you have these cells values entered as numbers (and not dates), then use the regular sum function, like this
=SUM(A1:A5)

If you have these cells values as times (or dates) then that would requires some work
Try using this one
=HOUR(SUM( B:B)-INT(SUM( B:B)))

Where you have the dates in column B


VBAXLMan

Saturday 4/25/2009 8:50:20 AM
Thu
Apr 23
2009

I need an MS Excel Formula that generates the total time taken from a list of times.?

Example.

I have a list of times (clock times) and I need to get the total time (duration).

5:30 am
5:45 am
6:15 am
6:30 am

The total duration time spent should be 1 hour and 15 mins or 75min.

Can I get an excel formula that does the above?


Answer

I am not sure if I got you correct here, but let me try this...

Option 1:
Now, if you have that list starting from cell A1 down
Paste this in B1
=MINUTE(A1)+HOUR( A1)*60&"min"
Then paste this down to get the others

That is one possibility answer to your question

Option 2:
Another one is this
=HOUR( A1)&" hours and "&minute(A1)&" min"

Option 3:
Or this
=SUM(A:A)


Let me know

VBAXLMan

Thursday 4/23/2009 11:41:34 PM

Tags

History