Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
excelQUESTION
 
Posts: n/a
Default Time displays in Excel

display time tenths of hours as result formula format Hour/mimute
  #2   Report Post  
Fred Smith
 
Posts: n/a
Default

You can use a custom format of hh.h to display tenths of hours for a time.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"excelQUESTION" wrote in message
...
display time tenths of hours as result formula format Hour/mimute



Reply
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 isolate my Excel server (automation) from other Excel instances? Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM
Excel file takes a long time to save ben@bikecenturies Excel Discussion (Misc queries) 1 February 3rd 05 12:27 AM
how can i add time in excel? Marcus Excel Worksheet Functions 2 January 7th 05 08:17 PM
how to open and see 2 excel work sheets at a time cwm Excel Discussion (Misc queries) 3 December 26th 04 01:27 PM
Excel Workbook opens after a very very long time Excel Worksheet Functions 2 December 18th 04 11:15 AM


All times are GMT +1. The time now is 07:16 AM.

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

About Us

"It's about Microsoft Excel"