Today I had a cute requirement which is pretty small. The user want to see the time difference between two different time stamps.
Steps to do this
1) Create a column Date1 of DateTime
2) Create a column Date2 of DateTime
3) Create another column of Datatype Calculated type.
then enter the following formula in that column settings
=TEXT([DATE2]-[DATE1],"H:MM").
then you are done
Showing posts with label Calculated fields. Show all posts
Showing posts with label Calculated fields. Show all posts
Tuesday, 10 June 2008
Subscribe to:
Posts (Atom)
