Date/hours problem (1 Viewer)

[AlaminK]

Can I ask for your help with a date \ hours problem without using VBA?

 

[Josef P.]

Have you tried the DateAdd function?

 

[AlaminK]

No. But that makes sense. Can you show me the process?

 

[Josef P.]

Oh!, I overlooked that you want to do this in Excel, since your post is in an Access part of the forum. DateAdd is a VBA function.
In Excel, however, simple adding should be sufficient.

StartDate	Hours	EndDate
5/3/2023 08:00	1,5	= [StartDate] + Hours / 24
= EndDate of line above	4	....

But maybe I have misunderstood you completely.

 

[CJ_London]

would be helpful to see some example data - what are you actually entering? a string saying '9 hours (1 Day and 1 hour)' or two separate columns for the hours - i.e. 9, 23, something else? or perhaps a start time and task time

task.... startDateTime...............timeTaken
A..........21/1/2023 08:00:00.....09:00:00
B..........22/1/2023 09:00:00.....15:00:00 - delay difference between the two startDateTimes