M Mark Aug 14, 2009 #1 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
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
L Luke M Aug 14, 2009 #2 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
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
