olivermahQrew Assistant Captain6 years agoduration between date created and date modified fieldTrying to create a formula field where the result shows the difference between the [date created] and [date modified]However I only want it to show the number of hours.tried doing this but it come up with a weird date and time as a result[date modified]-[date created]
2 RepliesReplies sorted by Most LikedSort ByMost LikedOldestNewestQuickBaseCoachDQrew Captain6 years agoyou can make it a formula numeric field type.ToHours([date modified]-[date created])olivermahQrew Assistant Captain6 years agothis worked perfect - thanks
QuickBaseCoachDQrew Captain6 years agoyou can make it a formula numeric field type.ToHours([date modified]-[date created])
Related ContentCreate a formula duration over 5 yearsDuration Fields with PipelinesFormula Checkbox and Durationtime durationDuration in minutes only
Recent DiscussionsSummary Table QuestionGoogle Search is backCan I use quickbase actions within the same table?Looking for Consultant: Add time tracking to existing task management app.Share your feedback on the new Qrew Discussions