datetime - convert date/time to hours in quickbase -


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