im trying to subtract Time IN (column C) and Time OUT (column F) but i failed as seen on thie screenshot below, this time data's are exported from our companies program system and its in csv filetype so at first i thought i could just save it as .xls but that did not help either, i also tried changing the formats of the columns by right clicking and going to format cells > number > custom > hh:mm:ss AM/PM but no luck still, i uploaded the entire csv file under Attachments too
\1
any help about this is greatly appreciated
Bookmarks