Combining two formulas to get one result

**jaycee66** · 10-24-2012, 04:16 PM

Sample combine in one.xlsxI am just trying to save myself some time and space on my spreadsheets(see attachment). I am dividing a square footage by the expected rate of work of one person . That result comes out as a decimal time, then I convert that to standard time. all I would like to do is combine/recreate the formula so that I don't have to convert in a separate field then hide the decimal time.

All help will be appreciated.

Thanks in advance

**jeffreybrown** · 10-24-2012, 04:19 PM

How about giving us what you are working with? The values the formuals.

**jaycee66** · 10-24-2012, 04:20 PM

on its way

**jeffreybrown** · 10-24-2012, 04:27 PM

In C2

=(A2/B2)/1440

custom format as mm:ss

**jaycee66** · 10-24-2012, 04:47 PM

jeffreybrown Thanks for the solution, but if you can explain one thing.

In my sample the formula I have in D2 is represented in h:mm but in the custom format you have mm:ss. It works out the way I wanted but it's just not jiving in my head. sorta like the Brits using "chips" or the french use "Pommes" instead of "french fries"? Can you explain? The formula not the fries thing, that' another forum.

**jeffreybrown** · 10-24-2012, 05:00 PM

Pomme Frites...I could go for some.

What do you want to convert to...minutes or hours?

24 = 24 hours in a day
1440 = minutes in a day

**jaycee66** · 10-24-2012, 05:29 PM

Jeff

Oh, I got the 1440 part just could figure the custom field to mm:ss. When I was figuring for h:mm. But hey it works regardless if its fries, frites or chips.