Ted Penner
asked on
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.