Skip to content
Gallery
Duration and AI
Duration and AI
HLPR AI
Control Table
Duration in Dutch
Duration in Spanish
Duration in French
Duration in German
Duration in Italian
DB Prompts
More
Share
Explore

icon picker
HLPR AI

Can we partly fix the wrong outcome?
info

improving the prompt

I added two columns and in each prompt I added a specific instruction and the result is what it should be. In the Unix variation I ask for a recalculation based on Unix values, but the result is not impressive at all. In this context the formatting is not the issue (as often is in text) but the ‘calculation’.

HLPR AI
1
startDate
endDate
calculatedValues
Duration (calculated)
deltaUnix-2-Terms
deltaUnix-3-Terms
Bill
hlprCheck
reviewCheckBox
1
Aug 28, 2023, 18:00
Aug 28, 2023, 18:02
0 years - 0 days
2 mins
2 minutes
2 minutes
2 minutes
2 mins
2
Aug 28, 2023, 18:00
Aug 28, 2023, 19:30
0 years - 0 days
1 hr 30 mins
1 hour 30 minutes
1 hour, 30 minutes
1 hour and 30 minutes
1 hr 30 mins
3
Aug 26, 2023, 18:00
Aug 28, 2023, 19:30
0 years - 2 days
2 days 2 hrs
2 days, 1 hour, 30 minutes
2 days, 1 hour, 30 minutes
2 days and 1 hour
2 days 1 hr 30 mins
4
Aug 30, 2023, 02:00
Sep 6, 2023, 02:00
0 years - 6 days
7 days
1 week, 0 days
1 week, 0 days, 0 hours
1 week
7 days
5
Jul 12, 2019, 07:30
Jul 20, 2019, 07:30
0 years - 8 days
8 days
1 week, 1 day
1 week, 1 day, 0 hours
1 week
8 days
6
Jul 12, 2019, 07:30
Sep 1, 2019, 00:00
0 years - 1 month
50 days 17 hrs
2 months, 19 days
1 month, 2 weeks, 2 days
1 month and 19 days
2 months
7
Jul 12, 2019, 07:30
Aug 29, 2023, 01:30
4 years - 1 month
1508 days 18 hrs
3 years, 1 month
3 years, 1 month, 2 weeks
3 years and 1 month
4 years
8
Aug 15, 2023, 13:00
Aug 29, 2023, 13:00
0 years - 13 days
14 days
2 weeks
2 weeks
2 weeks
2 weeks
9
May 16, 1940, 13:00
Aug 15, 1972, 13:00
32 years - 2 months
11779 days
32 years
32 years
3 months
32 years
32 years
10
Jul 25, 1939, 13:00
Aug 15, 1972, 13:00
33 years - 21 days
12075 days
33 years, 0 months
33 years, 21 days
33 years
33 years
11
Aug 15, 1972, 20:30
Oct 8, 2008, 20:30
36 years - 1 month
13203 days
36 years
36 years, 1 month, 23 days
36 years
36 years
12
Apr 25, 1985, 14:00
Oct 8, 2008, 20:30
23 years - 5 months
8567 days 7 hrs
23 years, 5 months
23 years, 5 months, 13 days
23 years, 5 months and 13 days
23 years
13
Aug 15, 1972, 20:30
Apr 3, 2011, 21:00
38 years - 7 months
14110 days 1 hr
39 years, 7 months
39 years, 7 months, 19 days
38 years, 7 months and 18 days
39 years
14
Apr 25, 1985, 14:00
Apr 3, 2011, 21:00
25 years - 11 months
9474 days 7 hrs
26 years, 11 months
26 years, 11 months, 1 week
26 years, 11 months and 9 days
26 years
15
Aug 30, 2023, 09:00
Aug 30, 2024, 09:00
1 year - 0 days
366 days
1 year
1 year
1 year
1 year
16
Aug 31, 2023, 05:00
Nov 3, 2023, 05:00
0 years - 2 months
64 days
2 months, 3 days
2 months, 3 days
2 months and 3 days
2 months
17
Aug 31, 2023, 05:00
Dec 28, 2023, 05:00
0 years - 3 months
119 days
3 months, 28 days
3 months, 4 weeks, 1 day
3 months and 28 days
4 months
18
Aug 31, 2000, 05:00
Nov 14, 2023, 05:00
23 years - 2 months
8475 days
23 years
23 years, 2 months, 14 days
23 years, 2 months and 14 days
23 years
19
Oct 8, 2008, 20:30
Apr 3, 2011, 21:00
2 years - 5 months
907 days 1 hr
2 years, 5 months
2 years, 5 months, 26 days
2 years, 5 months and 26 days
3 years
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.