A hospital administrator collect dates and times of needlestick injuries. The administrator wants to round the date/time column to the day, so that the time components are set to 0.
The original date/time values are in C1. The rounded values are in C2.
|Date and time of needlestick||Date|
|1/2 12:00||1/2 0:00|
|1/10 3:10||1/10 0:00|
|1/17 11:33||1/17 0:00|
To hide the time components, select and right-click the Date column and choose Format Column. Then, select a date display format without a time.
To round a date/time column to the nearest minute, complete the following steps.
The original time values are in C1. The rounded time values are in C2.
|Hrs Mins Secs||Hrs Mins|
A manager collects date and time data and wants to create a bar chart where each bar shows the data for a quarter. To create the categorical variable Quarter, the manager rounds the date and time data to include only quarter and year. The manager then changes the column format to display only quarter and year.
The original time values are in C1. The rounded date values are in C2.
|Date and Time||Quarter|