Split Formula Duration field into Hours and Minutes

Question

I have a [Total Time] (Formula Duration) field. I am using pipelines to send the data to Quick Books Online. QBO wants the hours and minutes separated. How can I split the [Total Time] into 2 fields [Total Hours] and [Total Minutes].

[Total Time] = 2:15

I need [Total Hours] = 2
and [Total Minutes] = 15

------------------------------
Mark Comish
------------------------------

donlarson · Answer

Mark,Congratulations on Pipeline access.&nbsp; You are among a select few to have the tool set.&nbsp; &nbsp;Please do a few posts on how it works and how easy or hard it is to work with.Total Hours is a Formula NumericToNumber(Left(ToText(ToHours([Total Time])),"."))Total Minutes is a Formula NumericToNumber("." &amp; (Right(ToText(ToHours([Total Time])),".")))*60
------------------------------Don LarsonPaasporterWestlake OH------------------------------

markcomish · Answer

Thank you Don!&nbsp; Worked like a charm.So for I have built Pipelines for Quick Books Online and Mail Chimp.&nbsp; I have had great success with building from Quick Base to Mail Chimp or Quick Base to Quick Books Online.I have not had good success going from Quick Books Online to Quick Base or from Mail Chimp to Quick Base.&nbsp; I have a support ticket in as it won't trigger in this direction.&nbsp; It has been several days and no solution yet.On the Pipelines that work they are great.&nbsp; Takes a little effort to get the hang of it but I really like them.&nbsp; Right now I have the following working...1. Update a contact in Quick Base and then a pipeline to also update the record in Mail Chimp (something I could never get to work with Zapier.&nbsp; Zapier only worked with a new record in Quick Base.2.&nbsp; When a time log is created in Quick Base it passes this info to Quick Books Online and creates a "Time Charge"Still lots of pipelines I want to build once they are working in both directions better.------------------------------Mark Comish------------------------------

markshnier__you · Answer

Mark. We appreciate the Pipeline info.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

donlarson · Answer

Mark,Thanks for the technical info.&nbsp;&nbsp;I have another request.&nbsp; How is the usage, pricing, limits laid out?&nbsp; &nbsp;I have no sense yet of what to tell customers Pipelines will cost them or how to budget.&nbsp; If Pipelines reaches its potential and makes it very, very easy to share data, will it blow up the bill.Have you ever been to a great Dim Sum restaurant?&nbsp; Suddenly you need a mortgage to cover all the things you grabbed.Would love to know what you are seeing about this side of the product.------------------------------Don LarsonPaasporterWestlake OH------------------------------

markcomish · Answer

I am on the Premier Plan.&nbsp; I believe we get 3 integrations in our plan.&nbsp; I am not sure the cost of adding above that.&nbsp; You can build all the Quick Base to Quick Base pipelines you want but they do count as "Steps" when they run.&nbsp; We get 2000 "Steps" per month.&nbsp; It is basically the number of times we run a pipeline.&nbsp; It is a bit confusing as it can be more than 1 "Step" each time a pipeline runs based on things it does.&nbsp; Sorry to be so vague.&nbsp; I have run 200 "Steps" in 10 days so the number seems like it will be enough for my use.&nbsp; Let me know if there is anything else I can share.------------------------------Mark Comish------------------------------

Forum Discussion

Split Formula Duration field into Hours and Minutes

Related Content

Create a formula duration over 5 years

Duration Formula

Duration in minutes only

Formula Checkbox and Duration

Delete Formula Button Error