Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timeend - TimeStart = wrong numbers
Endtime is a column(named Range) with time entries, StartTime(another named
Range) column with time entries and i need to be able to subtract the end time from the start time and display the result in a separate colum have tried to do it with named ranges but the resulting number is an unrecognizable decimal number I have been able to do it with absolute cell ranges but there are(will be) many many rows where it would not be practical to have to manually enter the formula per row and the person entering the information needs to be restricted to data entry only (no entering formulas) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timeend - TimeStart = wrong numbers
Just format the result cell as Custom|h:mm:ss
Excel stores date and time as numbers... 17-Oct-2008 12:00:00 PM is stored as 39,738.50 39,738 reprsent no of days from 1-Jan-1900 and 0.50 represent 12 hours... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "digitalmuse" wrote: Endtime is a column(named Range) with time entries, StartTime(another named Range) column with time entries and i need to be able to subtract the end time from the start time and display the result in a separate colum have tried to do it with named ranges but the resulting number is an unrecognizable decimal number I have been able to do it with absolute cell ranges but there are(will be) many many rows where it would not be practical to have to manually enter the formula per row and the person entering the information needs to be restricted to data entry only (no entering formulas) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timeend - TimeStart = wrong numbers
actually i figured it out thanks though for another way to resolve it !
"Sheeloo" wrote: Just format the result cell as Custom|h:mm:ss Excel stores date and time as numbers... 17-Oct-2008 12:00:00 PM is stored as 39,738.50 39,738 reprsent no of days from 1-Jan-1900 and 0.50 represent 12 hours... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "digitalmuse" wrote: Endtime is a column(named Range) with time entries, StartTime(another named Range) column with time entries and i need to be able to subtract the end time from the start time and display the result in a separate colum have tried to do it with named ranges but the resulting number is an unrecognizable decimal number I have been able to do it with absolute cell ranges but there are(will be) many many rows where it would not be practical to have to manually enter the formula per row and the person entering the information needs to be restricted to data entry only (no entering formulas) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of numbers with only two decimal places wrong | Excel Discussion (Misc queries) | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
i did something wrong | Excel Discussion (Misc queries) | |||
typed numbers entered in cell wrong | Excel Discussion (Misc queries) | |||
What's wrong with this? | Excel Worksheet Functions |