I have an app that's tracking how much time my newborn son is sleeping and I need to calculate the difference between the finish time and start time and account for the time between 2 different days. More specifically, if he falls asleep at 23:30 on a Saturday and awakes at 03:00 on a Sunday i need my result to show 3.5 hours.
I'm using two Date/Time fields with a formula of [Finish Date/Time]-[Start Date/Time] but my result is is something like this: 12-31-1969 07:32 PM.
Any help would be appreciated...
Question
Calculating the difference between date/time fields? My calc using Date/Time fields is [Finish Date/Time] - [Start Date/Time] -I need my result to show hours:minutes...
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.