TOTALHOURS () from beginning of current week and beginning of current month till now

[RECMAN_Systems]

Hi There,

Working with dates and specially time is rather confusing for me, therefore I really need to ask for help please.

I can not find the way to calculate the numeric value using TOTALHOURS() to get hours from beginning of current week till now in one formula and to get a numeric value of hours from beginning of current month till now.

Appreciate any help please.
Thanks in advance, Lovro

[GreenFlux]

Hi @RECMAN_Systems,

The expressions in this post aren’t exactly what you’re looking for, but they may give you a better understanding of how to work with durations in AppSheet:

Convert Birthdate to Current Age in Years/Months format Tips & Tricks 💡

Calculating the current Age based on a date-of-birth column: [48%20AM] Formula FLOOR(HOUR(TODAY()-[DOB])/365/24)&" yr "& FLOOR(MOD((HOUR(TODAY()-[DOB])/24),365)*12/365) & " mo" Line 1 HOUR(TODAY()-[DOB]) returns the number of Hours in the duration /365/24 converts hours to years, and FLOOR gives the number of full years, dropping the decimal. Line 2 (HOUR(TODAY()-[DOB])/24) returns the number of days in the duration MOD((...),365) finds the remainder in days, after removing the …

And here’s a good post by @Steve on rounding time:

FAQ: Rounding DateTime, Duration, and Time values Tips & Tricks 💡

Round DateTime value to nearest 5 minutes Round Duration value to nearest 5 minutes Round Time value to nearest 5 minutes

[Steve]

Beginning of current week to now:

TOTALHOURS(NOW() - (TODAY() - WEEKDAY(TODAY()) + 1))

Beginning of current month to now:

TOTALHOURS(NOW() - (TODAY() - DAY(TODAY()) + 1))

See also:

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

help.appsheet.com

DAY()

Day of month from Date, DateTime, or Time

help.appsheet.com

NOW()

Current date & time

help.appsheet.com

TODAY()

Current date

help.appsheet.com

TOTALHOURS()

Count of hours in Duration

help.appsheet.com

WEEKDAY()

Day of week from Date or DateTime

[RECMAN_Systems]

Thanks Steve you are a magician with time formulas.

But is there a solution to calculate only WORKING DAYS i/e WORKING HOURS?

Just as humble suggestion or expression request would be something like:

• BOWEEK - Beginning of Week where you can choose when the week actually starts and Sunday or Monday or …
• BOWWEEK - Beginning of Working Week where you can choose when the week actually starts and Sunday or Monday or …

Maybe even something to count working days i/e working hours from between two dates.

Or is eventually any thing similar already present in AppSheet? This would be extremely useful to calculate actual project performance.

Thanks again gor above solution and for future ones
Lovro

[Steve]

Unfortunately, AppSheet has a fixed definition of a week as Sunday to Saturday; there’s no way to change it.

WORKDAY() might be useful for computing working days. There is no equivalent for working hours.

See also:

help.appsheet.com

WORKDAY()

Computed date excluding non-work days

[RECMAN_Systems]

Thanks Steve,

What would be eventually the formula for counting working days from beginning of the month till now?

Thanks in advance

[Suvrutt_Gurjar]

Recently there was a discussion in the community on the topic and @OptimiX_XcrY has shared his expression and assumptions. I believe you could take a look at it.

Networkdays Questions

I think this formula generates wrong result for time intervals bigger than a week or so , this being because the number of weekend days until the workday result can be bigger than the double number of weekend days from the original time interval. I could also be wrong and just gone crazy searching for a solution for my situation.