LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Calculating days and hours

How can I convert decimal days, eg 12.375 days, to days and whole hours? Ex.
12 days 3 hrs.?
 
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
Calculating elapsed days and hours LauriS Excel Discussion (Misc queries) 4 August 25th 06 05:40 AM
Calculating number of hours accross days MTLeslie Excel Worksheet Functions 6 August 22nd 06 12:39 PM
Calculating number of hours between two days NMM Excel Worksheet Functions 1 October 21st 05 11:36 AM
Problem calculating Days/Hours etc between 2 dates Paul Sheppard Excel Discussion (Misc queries) 2 August 7th 05 10:32 AM
Help! I am stuck calculating Days, Hours, Mins please help OB1 Excel Worksheet Functions 2 November 15th 04 06:14 PM


All times are GMT +1. The time now is 09:10 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"