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 :-)))
