View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Hours & Minutes to Decimal

=A1*24
Format as General (or as Number, but don't leave it as Time as Excel did)

--
Kind regards,

Niek Otten


"SAR" wrote in message ...
|
| How do I convert 2:15 TIME VALUE (2 hours and 15 minutes) to 2.25
| hours?
| I'm really beat on this one. Please be specific. Thanks so much.
|
|
| --
| SAR
| ------------------------------------------------------------------------
| SAR's Profile: http://www.excelforum.com/member.php...o&userid=34172
| View this thread: http://www.excelforum.com/showthread...hreadid=539381
|