7 Replies Latest reply on May 18, 2018 7:32 AM by Shinichiro Murakami

# How to display total duration for some period?

Hi Community,

I try calculating the total duration during 4 months.

I comparing between decimal duration and duration based on hh:ss.

Between decimal duration and  duration based on hh:ss, it's similar position because I am sorting based on total duration during 4 months.

Is it possible create hhh:ss? or any other idea?

Thanks

Jehan

• ###### 1. Re: How to display total duration for some period?

HI Jehan

Only for the displaying purpose, I mean you cannot use this value for the calculation at all,

You can use this method.

Below formula create virtual number consist of

hours + Minutes

hours =100 minute = 30 ==>10030

Add ":" between tenth and hundredth.

Thanks,

Shin

• ###### 2. Re: How to display total duration for some period?

Hi Shin,

Yes, I could it.

Jehan

• ###### 3. Re: How to display total duration for some period?

HI Jehan,

You are very welcome.

Shin

• ###### 4. Re: How to display total duration for some period?

Hi Shin,

How are you?

I have a problem again even input that formula.

The time show like this:

Would you like to check it?

• ###### 5. Re: How to display total duration for some period?

What's the problem?

Could you clarify the issue and expected result?

Shin

• ###### 6. Re: How to display total duration for some period?

The problem is the duration shows 202:73 based on picture above.

Thanks

Jehan

• ###### 7. Re: How to display total duration for some period?

And you book is completely different from original and I am quite uncertain what do you want to accomplish here. (Time type??)