Can I Add or Calculate Total Work Hours in Mobile Spreadsheet?

Mobile apps
1

Hi,

I’ve been using the ONLYOFFICE mobile app to track work tasks in a spreadsheet, and I’m trying to sum total work hours from time ranges (e.g., 09:00–17:30).

On the desktop version I can usually calculate the difference and get a total duration, but I’m having trouble doing the same on the Android mobile app, the formula seems to return a date format or gives unexpected results.

Is there a correct way to calculate hours worked per day and sum them across the week inside the mobile spreadsheet? Or is this a known limitation on mobile?

Appreciate any tips!

Jhonn Marie

2

I’m still looking for a solution for making fields conditionally visible based on status or user role. If anyone has ideas, workarounds, or pointers, I’d love to hear them!

Thanks in advance :pray:

3

Hello @jhonnmarie,
What formula are you currently using?