PROPLEM -TIME ACTS AS TEXT

[azar3]

-What is done before: A table was created previously in Google Sheet in a task tab to calculate the working time on the tasks for the team, also columns were created for the in and out timing and working hours
- problem : all that was recorded previously in the start and end timing columns appears as text and thus the working hours appear VALUE mark
-Question :HOW to correct the timing(in&out) column to be as a timing formula at once because there are many rows, SO the hours column calculates the difference between them
....................................................................................
520/0previously time does not work

 

[etaf]

change the calculation to use timevalue
=D2-timevalue("00:01:00")
then copy down
that should change the TIME IN to a time value and not text
Check by changing format to a number and it should just show a normal number as that's how time is displayed under a number format

 

[azar3]

Sorry for the late review for some circumstances, and thanks the post have been resoled