Forum Discussion
COUNTIFS with weekday and timeframe
Thank you for sending the file by PM. The values in column I look like times, and they are formatted as times, but they are text values. You can do the following to convert them to real times:
Select column I.
On the Data tab of the ribbon, click Text to Columns.
Without changing any settings, click Finish.
I'll send the file back by PM.
yea, i simplified the table to not fill up the post with unnecessary information.
the source table is called "Source" and is structured as followed:
| A | B | C | D | E | F | G | H | I | J | K | L | M |
| Kassenname | Belegnummer | Datum | Vorname | Anrede | Name | Status | Wochentag | Zeit | Betrag | Verkäufer | Kundennummer | Kassenbuchnr. |
| Vinothek | KA22000830 | 19.08.2022 | Barverkauf | Gebucht | Freitag | 15:52:53 | 19,50 | Vinothek | 10001 | 27587 |
any clues why it tells "0"?
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
Thank you for sending the file by PM. The values in column I look like times, and they are formatted as times, but they are text values. You can do the following to convert them to real times:
Select column I.
On the Data tab of the ribbon, click Text to Columns.
Without changing any settings, click Finish.
I'll send the file back by PM.
- Thank you so so much!
I didn't expect this to be reason why its not working!
Thanks also to Patrick2788