Adjust Excel times in cells

[Beh162]

I'm having a bit of an issue where my formula won't work because their is a date appearing in front of the time. For some reason when I copy times from another excel worksheet it through the same date in front of the time. I've tried to custom adjust the formatting of the number, but the date still remains. MY formula is being effected by this because it disregards it because of the date.

Just incase this is my formula: =SUMPRODUCT(--(A11>='Front End'!B$25:B$72),--('Front End'!C$25:C$72>=A11+"00:15"))+SUMPRODUCT(--(A11>='Combo EE'!B$36:B$69),--('Combo EE'!C$36:C$69>=A11+"00:15"))

I'm not sure if there is a way to remove the date, or if I should adjust the formula

Excel3.png

[63falcondude]

If you want to remove the date and just leave the time, you can use a formula like this:

=MOD(A1,1) where the date/time is in cell A1 then copy/paste values and format accordingly.

[AliGW]

As your duplicate thread has more responses, I am closing this thread. In future, please do NOT post duplicate threads.

Continue here, please: https://www.excelforum.com/excel-for...om-a-cell.html