Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Timeend - TimeStart = wrong numbers
0 views
Skip to first unread message
digitalmuse
Oct 17, 2008, 10:05:01 AM10/17/08
to
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
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)
Sheeloo 95 64
Oct 17, 2008, 10:22:04 AM10/17/08
to
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
Oct 17, 2008, 11:54:08 AM10/17/08
to
actually i figured it out thanks though for another way to resolve it !
0 new messages