Thread: calculation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ajay ajay is offline
external usenet poster
 
Posts: 43
Default calculation

Hi,
Can you please advice me how to calculate time differences.,an example is
below for you to advice and solve my query..,
A B
1 01/03/2007 06:00:00 02/03/2007 07:30:00

The time (hours, mins & sec) taken between B1 to A1 is 25hours & 30 mins.
Can you please adivce me how to arrive to this formula.