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)

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)

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)