Excel Time Calculation - Any gurus out there?

  cstirrat 12:04 31 Jul 09
Locked

Hi,

Anyone know how to calculate the difference in time in Hrs/mins using two Excel times please?
e.g. 12:08:09 and 12:18:38 (10mins 29secs) I have a full spreadsheet to calculate and don't fancy doing it manually.
Thanks,
C.

  VoG II 12:07 31 Jul 09

With the later time in A1, the earlier time in A2

=A1-A2

format the result cell as Time.

  cstirrat 12:11 31 Jul 09

Thanks Vog - Guru of the Day Award to you.
Cheeers,
C.

This thread is now locked and can not be replied to.

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…