MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Is it possible ????


Posted by Danny from Belgium on January 19, 2002 5:55 AM

Hello,
Is it possible to change timenotifications in numbers with two decimals....ex:
9:30 change in 9,50
8:15 change in 8,25
7:45 change in 7,75
Is there a formula for ???
Sorry for my English
Thanks


Posted by Juan Pablo G. on January 19, 2002 7:36 AM

Use

=A2*24

Where A2 (And below) holds your times. And format the cells as General (Or number with 2 decimals)

Juan Pablo G.

Posted by Danny from Belgium on January 19, 2002 8:41 AM

Mucho gracia Juan Pablo :-)))