Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with time
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with time
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with time
This is fairly handy as an alternative
=TEXT(5.87/24,"h:mm") hth Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |