Recently, after lockdown, our Administration has started noting the In and Out time as 8.17 and 17.30. They have recorded the timings for about 100 employees for a week and when they tried to get number of hours, it was impossible for them to get the exact number of hours worked. Then I used the technique to convert those numbers to time by using copy and paste in word and find and replace "." with ":" and paste back to excel.
This is the out of way conversion of number to time. But is there any way for doing such conversion? Please guide me.
This is the out of way conversion of number to time. But is there any way for doing such conversion? Please guide me.