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
|