Is it poss to calc days,hrs, mins?

  cstirrat 16:42 05 Oct 09
Locked

Anyone know if is it possible to calculate the amount of days, hrs and mins betweem 2 given dates and times in Excel please?
e.g. 14/May/2009 09:42 - 13/May/2009 08:11 =?
C.

  Picklefactory 16:49 05 Oct 09

It's all in the formatting.
Format both of your source cells as
dd/mm/yy hh:mm:ss

and your result cell as
dd hh:mm:ss

and your sum in the result cell is simply earliest date - latest date

  cstirrat 17:07 05 Oct 09

Only getting lots hash's.

  VoG II 17:13 05 Oct 09

It should be latest date - earliest date

A1 14/May/2009 09:42

B1 13/May/2009 08:11

C1 =A1-B1

  cstirrat 17:31 05 Oct 09

Fabulous, many thanks

  Picklefactory 22:39 05 Oct 09

Thanks VoG™

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

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

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

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…