Help me to convert number (of days) into format 35:12:59

**erkamu** · 05-11-2018, 02:23 AM

Hello,
for some calculation I need to convert a number that represents number of days into time.
for example if I have "1" in next cell I need to have 24:00:00 .
if I have "2" in next cell I need to have 48:00:00...etc

Thanks!

**JohnTopley** · 05-11-2018, 02:31 AM

with 1 in A1

format B1 as [h]:mm:ss

in B1

=A1

**erkamu** · 05-11-2018, 03:02 AM

Thanks a lot for your help.

Help me to convert number (of days) into format 35:12:59

LinkBack

Thread Tools

Rate This Thread

Display

Help me to convert number (of days) into format 35:12:59

Re: Help me to convert number (of days) into format 35:12:59

Re: Help me to convert number (of days) into format 35:12:59

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] A number of days into weeks and days-How do you convert the decimal part of 0.571429

How to convert Number of Days to Months (With Only Business days)

[SOLVED] Convert number to Days/hours/Minutes after 31 days

Need formula or code to convert number(s) from custom format to number format

[SOLVED] Custom number format to convert 0 to '-' hyphen and convert negative numbers to red font

How do I convert start and end times to duration, days to number of days?

[SOLVED] how do I convert a number to number of years, months and days

Bookmarks

Bookmarks

Posting Permissions