How do I get total amount of hours in time format

[brianfar]

05:20
07:20
07:30
07:30
07:00
05:20
05:45
the above numbers are all individual times eg ( 5 hours and 20 minutes). I
need to add them all, which should come up to 45 hours and 5 minutes. The
format is [h]:mm for more than 24 hours, but the toatl it shows is 93:45
.. Can anyone show me which formula to use to add up time. I have tried all
other from different websites(mrexcel.com etc) and have tried all of ther
suggestions, but still am stumped

 

[Jacob Skaria]

I copied your data and tried =SUM(A1:A7) and formatted the ** formula cell
alone ** to custom format [h]:mm. It gives me 45:45


If this post helps click Yes

 

[Jacob Skaria]

May be one or more of your entries is displayed as rounded time. Format the 7
cells to [h]:mm to see whether any of the time is rounded off which is
actually more than 24 hrs..

If this post helps click Yes
---------------
Jacob Skaria

I copied your data and tried =SUM(A1:A7) and formatted the ** formula cell
alone ** to custom format [h]:mm. It gives me 45:45


If this post helps click Yes
---------------
Jacob Skaria

05:20
07:20
07:30
07:30
07:00
05:20
05:45
the above numbers are all individual times eg ( 5 hours and 20 minutes). I
need to add them all, which should come up to 45 hours and 5 minutes. The
format is [h]:mm for more than 24 hours, but the toatl it shows is 93:45
. Can anyone show me which formula to use to add up time. I have tried all
other from different websites(mrexcel.com etc) and have tried all of ther
suggestions, but still am stumped

 

[brianfar]

Hi Jacob,

I get the same result as you if i copy the files to another worksheet, but
still get a different answer after reformating the origanal spreadsheet.
actual
start finish finish Diff.
20:00 04:00 22:15 05:45

The above is an example of the the inputed data. eg start time at 20h00
,finish time is 04h00 hours, but they actually finished at 22h15, which gives
you a difference of 5 hours and 45 minutes . ( now the formula to get the
difference is the following:

=IF(Q14="","",IF((R14-S14)=R14,"",R14-S14))

and i think that is where my problem is.,because using the above formula,
the total adds up to 93.45
Hope this explains my dilema

Cheers
Brian

May be one or more of your entries is displayed as rounded time. Format the 7
cells to [h]:mm to see whether any of the time is rounded off which is
actually more than 24 hrs..

If this post helps click Yes
---------------
Jacob Skaria

I copied your data and tried =SUM(A1:A7) and formatted the ** formula cell
alone ** to custom format [h]:mm. It gives me 45:45


If this post helps click Yes
---------------
Jacob Skaria

05:20
07:20
07:30
07:30
07:00
05:20
05:45
the above numbers are all individual times eg ( 5 hours and 20 minutes). I
need to add them all, which should come up to 45 hours and 5 minutes. The
format is [h]:mm for more than 24 hours, but the toatl it shows is 93:45
. Can anyone show me which formula to use to add up time. I have tried all
other from different websites(mrexcel.com etc) and have tried all of ther
suggestions, but still am stumped