How can I Calculate Elapsed Total time in Column

[Donna]

I am using excel 2003 sp2.
How can I Calculate Elapsed Total time in Column G

ColumnE columnF columnG - formula in G is =F46-E46+IF(E46>F46,1)

starttime complete time elapsed
12:20 AM 12:35 AM 00:15
12:35 AM 12:37 AM 00:02
12:37 AM 12:38 AM 00:01
12:38 AM 12:38 AM 00:00
12:38 AM 12:39 AM 00:01
How can I get the total time?

 

[little_creature]

Hello,
You have accidenly landed to Mac group, but to do that use formula
=SUM() of appropriate rows of column G
Such as =SUM(g46:g50)

However I think there's might be mistake in your formula
=F46-E46+IF(E46>F46,1) should state =F46-E46+IF(E46>F46;1)

Hope this will help

 

[Donna]

Hi Thank you for the quick response..
My formula is correct though,
I had already tried that formula you suggested, but it doesn't work correctly.

 

[little_creature]

Hello,
=SUM(g46:g50) gives me value of 0:19
Which is sum of
00:15
00:02
00:01
00:00
00:01
That's right. Is that what you wanted? Am I overlooking something?

 

[JE McGimpsey]

I had already tried that formula you suggested, but it doesn't work
correctly.

That's not a particularly helpful response, since it doesn't let us know
what "doesn't work correctly" means to you.

The formula certainly SHOULD work correctly.

Do you have your Total time cell formatted as a Time (and if it could
exceed 24 hours, formatted with Format/Cells/Number/Custom [h]:mm)?