How do I get total amount of hours in time format
 

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

How do I get total amount of hours in time format
 

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


"brianfar" wrote:

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

How do I get total amount of hours in time format
 

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


"Jacob Skaria" wrote:

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


"brianfar" wrote:

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

How do I get total amount of hours in time format
 

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
"Jacob Skaria" wrote:

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


"Jacob Skaria" wrote:

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


"brianfar" wrote:

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