Show Time/Date Diff
How would I show the date Wed Sept 11, 2013, 2:30 pm in single columns such that the difference in hours and minutes could be calculated?
Book1.xlsx
Book1.xlsx
Last Comment
andrewssd3
You can just do normal arithmetic on dates, so say subtract one from the other. Then you format the result cell as "[h]:mm". This will show the difference in hours and minutes (even for periods longer than a day).
I would suggest you create a database for it
Use Microsoft Access (simple)
or .NEt and MSSQL (harder)
For access, just make table with a few fields ( Employee, inDate, inTime, outDate, outTime)
then make a form to add new items
It should be easy to calculate it that way
Use Microsoft Access (simple)
or .NEt and MSSQL (harder)
For access, just make table with a few fields ( Employee, inDate, inTime, outDate, outTime)
then make a form to add new items
It should be easy to calculate it that way
And the number format for the date you as for would be "ddd mmm dd, yyyy h:mmam/pm". The you enter the date and time as usual and it will be displayed as in your original question.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
