•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to calculate elasped time in excel when date and time are in the same cell?
I have series of data in the below format in excel. I want to calculate the elapsed time. I have tried multiple different way but nothing seems to be working.
Format: MM/DD/YYYY hh:mm:ss
Column: C4 - C2500
____________________________________________
Formulas I have tried:
Flash entery
Separating time into a different column (column D) and calculating batch hours ( column E) with this formula =(D4 - $D$4)*24
(Note: problem with 2 option is, after 12 hours period the batch hour goes to negative instead of getting added continuously. I did check the column format for column D and it was set 'hh:mm:ss')
Please help, I need to get this sorted soon 😭
Thank you
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#real-time data collaboration
#real-time collaboration
#Excel compatibility
#Excel alternatives
#generative AI for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#data visualization tools
#formula generator
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#elapsed time