Dear Friends,
I have two excel columns which contain "In" and "Out" times of staff members. I want to get the difference between these times. (Out - In)
A dot (.) has been used instead of colon ( when enter the times. As a result, the format of the available data as like this> i.e. 07.15 for 7:15 AM, 8 for 8:00 AM, 17.3 as 05:30 PM.
I'm struggling to find a way to do this.
Can You guys help me?
Thanks,
Rasika
Bookmarks