formatting time

  • Thread starter Thread starter Hillary
  • Start date Start date
H

Hillary

How do I take off the seconds in my time-formatted cells?
They look ok in the worksheet (h:mm) but in the formula
bar and when I merge the data into WORD, the seconds show
up. I also created a Custom format and that didn't work.
 
Hillary
You can't remove the seconds from the formula bar. Formatting only changes the display of the cell, while the formula bar shows the actual number

I tried a Mail Merge in word and it seemed to bring in the format that was set in my Excel file. Maybe this site might help

http://word.mvps.org/FAQs/MailMerge

Regards
Mark Graesse
(e-mail address removed)


----- Hillary wrote: ----

How do I take off the seconds in my time-formatted cells?
They look ok in the worksheet (h:mm) but in the formula
bar and when I merge the data into WORD, the seconds show
up. I also created a Custom format and that didn't work
 

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

Format time to not include seconds and AM/PM 2
Time Keeping 3
Excel Highlighting duplicates 0
Formatting Problem 2
Time Sheet - Calculating Time Differences for Totals 3
Total Hours 7
Timesheet - Formula 3
Excel VBA 1

Back
Top