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?

ajedv

timo
in Start and End time there should be ONLY the Time, without the date

example only 13:00
nothing more, i think you save also the day with the time in the app, but this has to be removed while exporting time only, as the date ist already in other colum.

https://www.exceltip.com/excel-date-time-formulas/entering-times-quickly.html
Excel stores dates and time as numbers and is used in calculation by the function. So it’s recommended to use dates as cell reference or using the TIME function instead of giving direct argument to the function. Check the validation of time values, or else the function returns #VALUE! Error.
Excel TIMEVALUE function only converts time values in text format to time values in number format.

timo

I'll try to ask again: Can you share a Excel file with the formatting that you expect? Via Mail (workinghoursapp@outlook.com)
What exactly is complicated to work with and why?
I am very hesitant to change the Excel export format as the last time I did, there was a big backlash from the users, see here

ajedv

timo

The problem is, that using the exported data with other functions the adding is not working