If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to add time above 24hrs...
Hi,
I am writing a leave tracker spreadsheet and want to add time up to the minute to keep track of overtime and comp time and credit hours, annual leave, sick leave etc. I have my cells formated to time hh:mm but when I add up the time that equates more than 24 hours, I get ####, which means the calculations are incorrect. I tried changing the type to hh:mm:ss and that seemed to add the time up correctly but I dont want to display the seconds...too much info, plus I only need up to the min. any help would be appreciated. Bill |
#2
|
|||
|
|||
how to add time above 24hrs...
2 things, widen your column so the result fit, then use custom format
[hh]:mm -- Regards, Peo Sjoblom "Bill R." wrote in message ... Hi, I am writing a leave tracker spreadsheet and want to add time up to the minute to keep track of overtime and comp time and credit hours, annual leave, sick leave etc. I have my cells formated to time hh:mm but when I add up the time that equates more than 24 hours, I get ####, which means the calculations are incorrect. I tried changing the type to hh:mm:ss and that seemed to add the time up correctly but I dont want to display the seconds...too much info, plus I only need up to the min. any help would be appreciated. Bill |
#3
|
|||
|
|||
how to add time above 24hrs...
#### can also mean that the column is not wide enough to disply the result.
If you go to the Format|Cells dialog, what do you seen in the Sample window? If the column is too narrow, then widen it. If it is in fact an error, then you will havee to look elsewhere for the problem, since what you describe doing should not produce an error. What does =COUNT(range) return, where range is the cell range that contains your times? My guess is that COUNT will return less than the number of "times" in that range, indicating that some of them are text instead of Excel date constants. With 18:00 in A1, 7:00 in A2, and a format of hh:mm, =A1+A2 would return 1:00. If (as I suspect) you wanted 25:00, you would need to use the custom format [h]:mm , or [hh]:mm if you want to see a leading zero on values 10:00. Jerry "Bill R." wrote: Hi, I am writing a leave tracker spreadsheet and want to add time up to the minute to keep track of overtime and comp time and credit hours, annual leave, sick leave etc. I have my cells formated to time hh:mm but when I add up the time that equates more than 24 hours, I get ####, which means the calculations are incorrect. I tried changing the type to hh:mm:ss and that seemed to add the time up correctly but I dont want to display the seconds...too much info, plus I only need up to the min. any help would be appreciated. Bill |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Time Zone suggestions for Outlook Calendar | Ben Knox | Calendar | 2 | October 20th, 2005 03:42 PM |
Time Calc - 24hrs vs 0hrs | Ltat42a | General Discussion | 9 | October 19th, 2005 09:14 PM |
Please Help! Ref Article ID 210504 | Telobamipada | New Users | 8 | May 9th, 2005 01:09 PM |
Time Zone Scheduling | JohnA | Calendar | 0 | September 14th, 2004 08:15 PM |
Use first record found in expression? | CASJAS | Running & Setting Up Queries | 17 | July 22nd, 2004 09:21 PM |