ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 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

Apr 25

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


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

If you have these cells values as times (or dates) then that would requires some work
Try using this one

Where you have the dates in column B


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

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


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?


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

Let me know


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