Calculating and summing work hours for a weekly schedule on Bubble.io

[yakuzen22]

Hi everyone,

I am creating a simple management system for my small business. Currently, I am working on the schedule management section. As you can see in the screenshot,

I have two inputs that retrieve data from the Database for the hours of a given day. The values are in “Text” format, formatted as time (00:00) and also include “Rest,” which indicates the staff’s day off. I am trying to calculate the total hours for the week, but I am struggling with both formatting and calculations. Can anyone help? Or is there a plugin that can assist with this? Thank you in advance for your help.

[yakuzen22]

nobody