•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Calculate difference in time by minutes
I'm trying to automate the scoring from a baby shower game. Guests guessed the stats of the baby (length, weight, date, and time) and the winner will be whoever was closest in aggregate. I've got the other categories sorted out, but time is giving me an issue.
I'd like to have the guess cell reference the actual time cell and give a difference in minutes. My solution so far has been =ABS(Actual-Guess) this works for the other categories but spits out nonsense for time.
Is there a conversion that needs to happen or am I trying to format this incorrectly?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#real-time data collaboration
#real-time collaboration
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives