example: created record on date 07/19/2016, 10:00am, wanted converted hours(timestamp) , display 54 hours in quickbase. appreciate help
if want convert timestamp hours in formula field can totimeofday()
, hours()
functions. want display hour of date created field can put formula formula-numeric field:
hour(totimeofday([date created]))
if need use formula - duration field reason, put of above through hours()
function:
hours(hour(totimeofday([date created])))
Comments
Post a Comment