Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 9th 09, 12:39 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 29
Default in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours

in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours, can I enter
7:30 and have the cell with a formula change it to 7.5

  #2   Report Post  
Old May 9th 09, 01:04 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 22
Default in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours

Are you trying to calculate elapsed time?

Gerry wrote:
in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours, can I enter
7:30 and have the cell with a formula change it to 7.5


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1

  #3   Report Post  
Old May 9th 09, 01:09 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours

You could use another cell to hold this formula:

=a1*24
and format as general (or number)

Gerry wrote:

in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours, can I enter
7:30 and have the cell with a formula change it to 7.5


--

Dave Peterson


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
wages - multiply hours and minutes by number of hours worked Carol (Australia) Excel Discussion (Misc queries) 6 April 1st 07 01:16 AM
how do i show negative time in hours minutes john tyler Excel Worksheet Functions 0 March 6th 06 09:47 PM
Problem converting Hours to Days, Hours, Minutes Zyzzx Excel Worksheet Functions 4 October 24th 05 04:19 PM
Convert hours and minutes in time format into fractions of hours.. Akern Excel Worksheet Functions 4 April 21st 05 02:56 PM
add column of minutes, show total in hours & minutes glider pilot Excel Worksheet Functions 1 December 30th 04 11:27 PM


All times are GMT +1. The time now is 09:28 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017