Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Convert a time Format into a Real #
Name: themikewinn Date: February 26, 2009 at 22:26:44 Pacific OS: Windows Vista Subcategory: Microsoft Office
Comment:
I want to create a spreadsheet that allows me to do the following: 1) Track a clock in time from an agent. 2) Track the current time at any given updated time (F9 key) 3) I want to be able to come with a total hours worked. 4) I want to now use the Total Hours worked for the day, along with some previouse times, and get a whole number of hours and minutes in a decimal format so that i can divide it by a whole nubmer.
Summary: As far as I know, you can not input any negative number into a TIME formatted cell. If you are inputing the data from an outside program, what may be happening is that those digits formatted as TIME w...
Summary: I'm attempting to analyze data from 2 brands of data recorders. One recorder collects data in hours and minutes (for example, 14:30), the other records times as minutes into the day (using the same e...
Summary: Hi, Here is some information on Time in Excel. Times in Excel appear difficult, but if you ensure that all data entry follows a time format that Excel recognizes, you will be able to add and subtract ...
