Looks like you have additional spaces in the cells with times try using TRIM function, e.g.
=TRIM(F1)-TRIM(c1)
format result cell as h:mm
Looks like you have additional spaces in the cells with times try using TRIM function, e.g.
=TRIM(F1)-TRIM(c1)
format result cell as h:mm
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks