Need help with time

[Guest]

At work we use Excel 2000. Yeah old especially for a billion dollar
industry. Here is question. I built a program to calculate time for my
employees. Problem is that Excel uses standard 60 minutes and our time clock
uses time in 100. so I get times like 5:87 etc. Can I format excell 2000 to
take the time in this format and then do the addition/subtractions etc
accurately? My employees are paid to the minute of their time which is kind
of nice.

Thanks in advance

 

[robotman]

You can build a string to format the minutes in 100. I don't think
Excel has a built in format to display the minutes in 100 increments.

An example formula at the spreadsheet level, with the time is in Cell
A1:

=HOUR(A1) & ":" & MINUTE(A1) * 100/60

Hope that helps...

John

 

[Keith74]

This is fairly handy as an alternative

=TEXT(5.87/24,"h:mm")

hth

Keith