Hi All,
Im trying to calculate the number of hours that has elapsed say form one cell.
Cell A1 has a string which contain 09:45-13:57 how would I calculate the hours elapsed.
Can anyone point me in the right direction.
Regards
Dogo
Hi All,
Im trying to calculate the number of hours that has elapsed say form one cell.
Cell A1 has a string which contain 09:45-13:57 how would I calculate the hours elapsed.
Can anyone point me in the right direction.
Regards
Dogo
Hello and welcome to the forum.
You can use this:
=RIGHT(A1,5)-LEFT(A1,5)
Formatted as Custom h:mm
or you can use this:
=(RIGHT(A1,5)-LEFT(A1,5))*24
for the number of hours
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks