•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Negative Value Elapsed Time
Need a little help with making the negative values show up.
Column C is "Start" time. Column E is "End" time.
I want to show the elapsed time between Column E and Column C. If the start time is before the end time, the math is easy.
But if the times are reversed, then I get these ###s. In this case, they're not really start and end time. More like you need to perform the activity in Column C before the activity in Column E. So if these actions were performed in reverse order, I want to know the amount of time elapsed.
Bonus if you can help me call out this discrepancy vs what Copilot did for me in this example.
Thanks!
[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
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#Elapsed Time
#Negative Value
#Start Time
#End Time
#Column C
#Column E
#amount of time elapsed
#perform activity
#reverse order
#Copilot
#activity