Posted by Jonathan on May 01, 2000 12:37 PM
I want to create a spreadsheet that will do the following:
1) Convert time from hours & minutes to 1/100 hours.
2) Add the results.
Here is an example to clarify: Joe Smith clocks in at 7:58 am and then clocks out at 4:05. If we convert the time to 1/100s, it is 7.97 and 16.08, for a total of 8.11 hours.
How can I create a formula that will convert the time from 7:58 to 7.97, 4:05 to 16.08, and so on?
I thought this would be simple until I actually sat down and tried it!