Subtracting Time
 

I have for example 8:15:29 AM in one cell and 9:33:15 AM in another cell and
I need the amount of time between the the two

Subtracting Time
 

Assuming times are in A2 and A3 respectively:
=A3-A2

format cell as time. (answer is 1:17:46)
if you want answer in hours, multiply by 24
In minutes, multiply by 24*60
in seconds, multiply by 24*60*60

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mark" wrote:

I have for example 8:15:29 AM in one cell and 9:33:15 AM in another cell and
I need the amount of time between the the two

Subtracting Time
 

=B2-A2 and format as [h]:mm:ss
--
David Biddulph

Mark wrote:
I have for example 8:15:29 AM in one cell and 9:33:15 AM in another
cell and I need the amount of time between the the two