Custom Formatting Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I need help doing a custom format in Excel.

If I have a field that represends the number of days in numberic format, say 3.5 (3 1/2 days). I want to covert it to Days:Hours:Minutes. AKA 03:30:00 for 3.5.

Can someone help me with that? The Excel format "dd:hh:mm" takes 3.5 and displays "03:22:19" which is incorrect.

Any help would be appreciated.
 
Hi
if I put 3.5 in a cell and format it with the custom format
D:hh:mm

I'll get
3:12:00

whichs sounds correct for me 812 hours = 0.5 days)
 
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

Problem formatting dates from CSV file 2
How to Format numbers from percentage points to basis points 1
Excel 2003 - Time Formats 5
Date / Time problem 4
custom date format 1
Converting dd:hh:mm to [h]:mm not working. 3
custom date format changed in mail merge 10
custom date format 6

Back
Top