ふたつのdatetypeのフィールドの差を00:00のように表したい

t.oshikiri · 2024-08-01T07:31:24.604Z

bubble初学者です。
今回start_timeとend_timeという二つのdate typeのフィールドを用意しました。
この二つの差を用いて経過時間を求めたいと考えています。その際にこの経過時間を保存するフィールドであるwork_timeの方をdate range typeにしようと思ったのですが、英語の説明をよく理解できず、この二つの差をdate range typeとして保存できるのか、またできないのであれば差を求める以外に経過時間をdate range typeを用いて表すにはどうしたらよいかどなたかわかる人がいましたら教えていただきたいです。二つのdateの差は現在numberで保存しているのですが、経過時間も00:00のような形で表したいと考えて今回質問しました。

jonah.deleseleuc · 2024-08-01T09:24:21.688Z

Hey there,

I used Google translation to understand your question, I hope there’s nothing lost in translation. You can indeed save date ranges in your database. However, in my experience, it has been easier to create two fields as “start date” and “end date” rather saving it as a date range. If you need to use a date range on the front end you can calculate the range easily by doing end date minus the start date. Is there any particular reason why you can’t do that? Regardless, you can still save date ranges.

All the best,

t.oshikiri · 2024-08-02T03:09:04.805Z

Dear jonah.deleseleuc,

I am not very fluent in English, so I used Google transration to write this message.
I am developing a simple time and attendance system. So I want to record the time worked and display it in a format like 00:00. This is the reason why I don’t do end date minus the start date. If I do so, the answer is saved as a number. But then, it cannot be displayed in a format like 00:00.
I want to display the time worked in a format like that.

Best regards,
t.oshikiri

jefeoliveira22 · 2024-08-02T03:32:57.456Z

First you need total minutes wich is: date2 - date1 formatted as minutes
like this:

Next you need to format it to get hours and minutes like this:
(hour) total minute's value / 60:floor : (minutes) total minute's value <-modulo->60

example:

t.oshikiri · 2024-08-02T05:00:35.423Z

Dear [jefeoliveira22]

Thank you for your reply.
I am not good at English, so I used Google translation. After trying your method, I was able to display the time worked as shown in this picture.

image1030×119 4.53 KB

How can the time worked be displayed as a format like 00:00.

Best regards,
t.oshikiri

michitomo · 2024-08-02T05:38:47.731Z

chatgpt.com

ChatGPT

A conversational AI system that listens, learns, and challenges

t.oshikiri · 2024-08-02T06:07:45.057Z

ご返信ありがとうございます！
いただいたリンクをもとにやってみます！