LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
NoelH
 
Posts: n/a
Default to convert Minutes into Day:Hr:min (not as fraction)

Hi to all

The really simple things are the hardest!
I have a figure which is in minutes say 10856, and I which to convert it
into days:hrs:min. ie 7 days 12 hrs and 55 mins and 8 sec.
each attempt at the formula has given me fractions of hours, mins etc which
I have to convert back to whole minutes.

Is there a simple way??
any help will be greatly appreicated.

Thanks in advance

Noel
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert a number of minutes into hours and minutes? gyrkin Excel Worksheet Functions 3 August 18th 05 11:12 PM
Convert Time to Minutes Brenda Rueter Excel Discussion (Misc queries) 6 March 3rd 05 08:09 PM
convert hours and minutes to minutes idaho Excel Discussion (Misc queries) 2 January 27th 05 09:45 PM
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM
convert minutes into hours:minutes tlf713 Excel Worksheet Functions 3 December 15th 04 10:42 PM


All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"