LinkBack URL
About LinkBacks
Sorry that there is something wrong with my previous formula, e.g. if logs out is 12:59PM and logs back in is 1:00PM.
This may correct:
=IF(A1<>A2,"",TIMEVALUE(LEFT(B2,LEN(B2)-2)&" "&RIGHT(B2,2))-TIMEVALUE(LEFT(C1,LEN(C1)-2)&" "&RIGHT(C1,2)))
Sorry that there is something wrong with my previous formula, e.g. if logs out is 12:59PM and logs back in is 1:00PM.
This may correct:
=IF(A1<>A2,"",TIMEVALUE(LEFT(B2,LEN(B2)-2)&" "&RIGHT(B2,2))-TIMEVALUE(LEFT(C1,LEN(C1)-2)&" "&RIGHT(C1,2)))
Quang PT
lol thanks heaps bebo I was about to come back and try and ask that question as I have completed most of the project till I came up to that problem
thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks