EXPORT time is exported as date AND time instead of hh:mm

ajedv

WorkingHours version: 2.6.5
OS + version: W10 21H1 19043.867
When export several Tasks, the export contains
Date | Date start time | Date stop time | Durance in hh:min | other fields ...

That is very bad for me, as i need the Time in hh:mm and not incl. date, as the date is already in separate field
So i need the start and stop time only as time without date. same time format as Pause and durance.

timo

WorkingHours exports the time as "time" and not formatted text in any particular way. The program you use to display the file is determining the format. So you can change that in Excel itself, for example.

ajedv

regretfully that is not true, the contend of the field is an serial number containing date AND time.
the formatting displays the selected variant, but for calculation the date is still there.

Rasputin

Removing the date won't be an option because it can happen that stop time is smaller than end time.
As you don't need that, record a small macro which extracts hh:mm from the given date/time

timo

Rasputin Removing the date won't be an option because it can happen that stop time is smaller than end time

no that should not happen. If the work unit expands to the next day, the app will split it into 2 work units (one for each day)

ajedv

The Problem still exist and make an export to excel for working with that data very complicate.

timo

Can you share a Excel file with the formatting that you expect?
What exactly is complicated to work with and why?