Calculate working hrs

[Shabbo]

Dear Sir,

Please help me to calculate number of working hrs.

 

[vletm]

Sheets D & E-columns shows me as texts (not as those should be).
Cell F2 as basic formula with format, which could work better with Your settings.
... copy it down as You need.
It shows working hours as You've asked.

 

[Shabbo]

Sheets D & E-columns shows me as texts (not as those should be).
Cell F2 as basic formula with format, which could work better with Your settings.
... copy it down as You need.
It shows working hours as You've asked.

Dear Sir, its not working from date 13-06-2025 showing value if I put 12-06-2025 in same cell its working but when I change to 13-06-2025 in same cell it's not working, please help.

 

[vletm]

Do You mean from this (below snapshot) ?

Your Time In & Out are texts like month/day/year hour:minute.
Do You normally use format like day/month/year hour:minute ?
How did You 'get' that data?
... csv-file? If so, then can You send it?
Is there any working over midnight?

 

[Shabbo]

Do You mean from this (below snapshot) ?
View attachment 90285
Your Time In & Out are texts like month/day/year hour:minute.
Do You normally use format like day/month/year hour:minute ?
How did You 'get' that data?
... csv-file? If so, then can You send it?
Is there any working over midnight?

Dear sir,

It's a system generated file, and yes highlighted rows need to calculated with number of hrs.
Please advise.

 

[vletm]

You comment only one question ... hmm?
My advice is that You should able to answer to questions.
I guessed the rest of those ...
Modify cell F2 formula to =IF(E2<>"",RIGHT(E2,5)-RIGHT(D2,5),"")
It will work without nightshifts.

 

[Logit]

Paste in F2 : =E2-D2 . Drag down column. Format CUSTOM as time "15:00"

That will solve your total time worked issue.

 

[vletm]

Logit​

Did You test it (same formula as mine original sample) with row 15?
Mine nor Shappo's didn't work? ... because challenges with order of day/month ( #4 snapshot )

 

[Logit]

Row 15 :

ABC

ABC

8​

06/13/2025 09:43

06/13/2025 18:40

8:57​

C/In

101​

0​

FP

 

[vletm]

Yes, nice to know that at least somewhere it works.

 

[p45cal]

F2:

=DATE(MID([@[Time Out]],7,4),LEFT([@[Time Out]],2),MID([@[Time Out]],4,2))+TIMEVALUE(MID([@[Time Out]],12,5))-DATE(MID([@[Time in]],7,4),LEFT([@[Time in]],2),MID([@[Time in]],4,2))-TIMEVALUE(MID([@[Time in]],12,5))

or

=DATE(MID($E2,7,4),LEFT($E2,2),MID($E2,4,2))+TIMEVALUE(MID($E2,12,5))-DATE(MID($D2,7,4),LEFT($D2,2),MID($D2,4,2))-TIMEVALUE(MID($D2,12,5))