1 min readfrom 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?

submitted by /u/Slaedden
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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