Excel Time Calculation - Any gurus out there?

  cstirrat 12:04 31 Jul 2009
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 2009

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

=A1-A2

format the result cell as Time.

  cstirrat 12:11 31 Jul 2009

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

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Lightwell software lets you create mobile apps without using code

Best value Mac: Which is the best £1249 Mac to buy

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?