Convert minutes to hours and minutes text

[David Crossmier]

I have a large library that contains a field for total minutes. (entered manually) I'd like the display of the minutes to be textual -- hours then minutes. I cannot make hours & minutes independent fields because of other calculated fields.

For example, if the totalMins field contains 62, I'd like to build/calculate and display a text field of "1 hour, 2 minutes".

I've been able to create 2 calculated fields correctly for the hours & minutes components. But is it possible to "build" another hours + minutes string for display as I describe in my example?

Thanks, David

[Murdy]

Hi David,

Your request can't be completed natively within Memento (just yet). However, I have a solution that would solve your problem and take less than 1 minute using Google Drive.

Assuming that you already have the formulas (mentioned below to help others): 

- (a) your hours calculation is: "minutes"/60

- (b) your minutes calculation is "minutes"-("hours calculation"*60)

This gives you 3x fields (1. original total minutes, 2. hours, 3. minutes)

- Add an additional field for the result. Sync the database with Google Drive.

- Within Google Drive, add the following formula to the final field =CONCATENATE(B2," Hours ",C2," Minutes")

- Replace B2 and C2 with the corresponding letters that relate to your hours calculation & minutes calculation fields.

Once Complete, the results with show as desired outcome (example: 70 minutes will display 1 Hour 10 Minutes)

Copy & Paste the formula down the whole list and viola.

- Sync database back to the phone.

Future amendments will only take 10 seconds and you'll only need to copy & paste the new results.

Results

Formula

Results In Memento

[Mr Mukura]

Thanks for the guide here.

My query is if for example I had a data_entry library, which synced to gdrive form(ula) processing, then could I make a report library whic syncs from the gdrive sheet but maintain one way data flow... I've played around with it and think it should work given link parameters - but are they constant, and would this be a quicker work around?

Cheers