Home

How Do You Format a Time Period?

Piedmont_Jim
Occasional Visitor

I need to format a time period rather than a period in time. That is, I need to be able to represent something like ten minutes without it being referenced to a date and/or time of day like: "1/10/1900 12:10:00 AM". I just want to add time periods together to get a total time period, like:

 

0:20 + 0:50 = 1:10

 

Can this be done without bending over backwards algorithmically?

1 Reply

Depends on where is your time, in cells or within the formula

image.png

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies