News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... TimeSheetLine Entity

Finance | Project Operations, Human Resources, ...

Suggested answer

TimeSheetLine Entity

(2) Share

Report

Report

Posted on by tmj1

7

Hi

When I export the TimeSheetLine entity via Datamanagement to excel (or other format) the "Hours" columns comes out with format .000000 or -.750000 or 7.500000 - I have tried multiple workarounds, but i do not seem to be able to find a workable solution.

Does anyone know how to change the formats of these columns in this entity?

Thanks

Tom

Categories:

Dynamics 365 Finance

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 9,833 Super User 2024 Season 2 on at

Like (0)

Report

TimeSheetLine Entity

Hi @tmj1,

This field is of the real type, so it's normal that you'll find this format.

For excel, you'll automatically modify the format otherwise you can export in csv instead of excel.

Best regards,

Mohamed Amine MAHMOUDI
André Arnaud de Cal... 291,405 Super User 2024 Season 2 on at

Like (0)

Report

TimeSheetLine Entity

Hi Tom,

Can you share a screenshot of the current outcome and can you also tell us what exact format you would like to have?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,405 Super User 2024 Season 2

#2

Martin Dráb 230,455 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans