Skip to main content
Question

Split Formula Duration field into Hours and Minutes

  • March 7, 2020
  • 0 replies
  • 156 views
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • March 7, 2020

Mark,

Congratulations on Pipeline access.  You are among a select few to have the tool set.   Please do a few posts on how it works and how easy or hard it is to work with.


Total Hours is a Formula Numeric
ToNumber(Left(ToText(ToHours([Total Time])),"."))

Total Minutes is a Formula Numeric
ToNumber("." & (Right(ToText(ToHours([Total Time])),".")))*60



------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Terms & ConditionsAccessibility statement