How to display hours, minutes, seconds when subtracting cell b16 time from cell b17

[VICTORIE]

I've seen response here that say to use [h]:mm:ss but I don't know what I'm doing. How is the forumla supposed to look using cells b17 and b16.

Thank you

[jeffreybrown]

I've seen response here that say to use [h]:mm:ss but I don't know what I'm doing. How is the forumla supposed to look using cells b17 and b16.

Thank you

[h]:mm:ss is a custom format which would be applied to the result cell. It will allow for times past 24 hours.

[VICTORIE]

Thanks for your quick response

I am trying to calculate production time, the difference between two cells. I was able to do so easily using =MINUTES(b17-b16) but sometimes the difference in time is greater than 59 minutes so I would like to see the hours and minutes displayed. How would I format that?

[ChemistB]

Assuming B17 and B16 are times.

=B17-B16 should work. Then format your cells (right click> Format Cells) to Custom hh:mm should work unless, as mentioned earlier, it can be more than 24 hours.
Does that work for you?

[jeffreybrown]

What do you have in B17 and B16?

On a test I did...

B17 = 5:00:00 AM
B16 = 6:11:00 AM

Formula >> B17 - B16 >> formated as h:mm:ss >> produces 1:11:00

Sorry ChemistB, I did not refresh to see your post...

[ChemistB]

No apologies necessary. I'm usually the slow man on the respond button.

[VICTORIE]

Thanks to you both, it is working exactly the way I wanted it to. I am so glad you guys are here to help!

Have a great weekend

[jeffreybrown]

We are glad to help.

Thanks for the feedback and hope you have a Happy & Healthy weekend yourself