Thread
:
time serial number
View Single Post
#
4
Posted to microsoft.public.excel.misc
Roger Govier[_3_]
external usenet poster
Posts: 2,480
time serial number
Hi Kristina
On the PT, double click on the relevant field headerNumberCustom [h]:mm
--
Regards
Roger Govier
"Kristina Demers" <Kristina
wrote in
message ...
Hi,
I need to only show time as time... for example someone worked on a
specific
project for a certain length of time. I've created a pivot table in
excel.
On the data tab I have some numbers which are formatted as hours:min:sec
(for
example - 3:45:20 = 3 hours, 45 mins, 20 sec.). How do I get that stat to
go
over to the pivot table correctly? When I update to the pivot table I
only
get 0s. I've tried different formats and nothing seems to work.
I'd appreciate any help in fixing this... thanks,
~kristina
"Bob Phillips" wrote:
You could use helper columns with formulae of
=INT(A1)
etc. and pivot the helper columns.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Bob Gotti" wrote in message
...
I have a long spread sheet that has two columns of dates (Received and
Finished) that I am importing into a pivot table and would like to use
the
dates in my pivot, less the time. For daily use, I do use the time
with
the
date, but only
want the date for use in the pivot table. How can I eliminate the time
serial number, before importing into my pivot, apart from editing each
individual cell?
Have a \\\|/// Blessed Day
(o o)
---oOO-(_)-OOo---
But as for me, I watch in hope
for the LORD, I wait for God my
Savior; My God will hear me.
(Micah 7:7)
Reply With Quote
Roger Govier[_3_]
View Public Profile
Find all posts by Roger Govier[_3_]