If you have time-critical tasks to track, it's easier to read duration in hours and minutes rather than fractions. In this video, learn how to create a custom field with a formula that displays the whole hours represented by a task's duration.
- [Bonnie] Hi, I'm Bonnie Biafore. … With short, time-critical tasks, … seeing duration in hours and minutes is easier … to read than decimal numbers. … Today, we're going to look at how to set up a custom field … with a formula to display duration in whole hours. … Our first challenge is that the Duration field … is a built-in field, … so you can't format it. … But you can format a custom text field. … That's what we're going to use … to do our formatting of duration. … I'm going to right-click the Start heading … and choose Insert Column on the shortcut menu. … I'm going to add Text10 as my custom text field. … To work on this text field, … I'm going to right-click its heading. … And then on the shortcut menu, choose Custom Fields. … That opens up the Custom Fields dialog box … right to the field that I've just inserted. … I'm going to jump down to the Rename button, click that, … and I'm going to name this with the format … that I'm going to eventually create, … which is two digits for hours and two for minutes, …
Author
Updated
2/16/2021Released
1/9/2018Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Intermediate
Duration
Views
Related Courses
-
Outlook Quick Tips
with Garrick Chow33m 46s Intermediate -
Excel: PivotTables for Beginners
with Dave Ludwig23m 52s Beginner
-
New This Week
-
Introduction
-
Welcome50s
-
-
Previous Microsoft Project Tips
-
Create a hammock task4m 7s
-
Rename column headings3m 58s
-
Save a new view5m 53s
-
Find hidden task bars4m 56s
-
Set additional baselines5m 6s
-
Find a command4m 29s
-
Track ancillary project costs11m 33s
-
Designate who reports status3m 21s
-
Control how a view prints5m 42s
-
Switch date constraints2m 21s
-
Data entry shortcuts2m 46s
-
Find in-progress assignments3m 13s
-
Beware the Autolink option3m 48s
-
Make exporting data easy5m 22s
-
Set currency options1m 47s
-
Update OLE links3m 58s
-
Share customized elements3m 31s
-
Document your customizations4m 23s
-
DEPRECATED
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Format duration, part 1: Display whole hours