Formatting Cells for Time

  • Thread starter Thread starter roddo
  • Start date Start date
R

roddo

I would like to Format cells so that they display time as eg. 3hrs
30mins
Do I need to add a custom format? I
 
You do,

h "hrs" "mm" mins"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display Text with Formulas 1
Date formatting 4
Formatting Cells - Hex Values 3
Time in format hh:mm:ss.milliseconds 8
Excel Convert Datetime Stamp to HH and MM Worked 7
HDMI is a terrible format and I wish it never existed 2
How to Calulculate Hrs and Mins between time frames 2
formula for decimal point 4

Back
Top