Forum Discussion
DonLarson
Qrew Commander
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
------------------------------
DeepaPrashant1
4 years agoQrew Cadet
Thank you Mark. I was looking for this as well. However, I need to add seconds as well and so have also created a pure StartDate and End Date and Start Time and End Time fields in Date only and Time only formats as the Date-time format does not support seconds.
It appears the rounding in minutes is throwing my duration off. So if my Start Date and Time is 07-03-2020 23:02:30 and End Date and Time is 07-04-2020 06:03:05, i got my hours to calculate as 7 hours, but minutes should be 0 and seconds 35. Not getting that!
Can you help?
------------------------------
Deepa Deepa
------------------------------
It appears the rounding in minutes is throwing my duration off. So if my Start Date and Time is 07-03-2020 23:02:30 and End Date and Time is 07-04-2020 06:03:05, i got my hours to calculate as 7 hours, but minutes should be 0 and seconds 35. Not getting that!
Can you help?
------------------------------
Deepa Deepa
------------------------------