Converting hr min sec into numbers
 

I am looking at invoices that have captured time spent on activity,
the system reports duration in hr min sec ( 5:47:06). I need to
convert this into a numbers that I can manipulate I could create a
formula such as = (5*3600) + (47*60) +06, however that is very manual
and I am looking at too many numbers. Is there something else I can
do? Thanks Shiftaw

Converting hr min sec into numbers
 

=A1*24*60*60 (or =A1*86400) and format the result as General or Number, not
as Time.
--
David Biddulph

wrote in message
ps.com...
I am looking at invoices that have captured time spent on activity,
the system reports duration in hr min sec ( 5:47:06). I need to
convert this into a numbers that I can manipulate I could create a
formula such as = (5*3600) + (47*60) +06, however that is very manual
and I am looking at too many numbers. Is there something else I can
do? Thanks Shiftaw

Converting hr min sec into numbers
 

the way time is stored it is a fraction of a day
If you change your format to general
it should dispay 0.241042
if not it is text and you will need to convert it to time
one method to convert it to time is
=time(value(left(A1,if(len(a1)=7,1,2))),value(mid( A1,if
len(A1)=7,3,4),2)),value(right(A1,2)))

will the fraction of a day do what you want?
if you need it in seconds

=A1*24*3600


" wrote:

I am looking at invoices that have captured time spent on activity,
the system reports duration in hr min sec ( 5:47:06). I need to
convert this into a numbers that I can manipulate I could create a
formula such as = (5*3600) + (47*60) +06, however that is very manual
and I am looking at too many numbers. Is there something else I can
do? Thanks Shiftaw

Converting hr min sec into numbers
 

On 17 Aug, 13:10, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=A1*24*60*60 (or =A1*86400) and format the result as General or Number, not
as Time.
--
David Biddulph

wrote in message

ps.com...



I am looking at invoices that have captured time spent on activity,
the system reports duration in hr min sec ( 5:47:06). I need to
convert this into a numbers that I can manipulate I could create a
formula such as = (5*3600) + (47*60) +06, however that is very manual
and I am looking at too many numbers. Is there something else I can
do? Thanks Shiftaw- Hide quoted text -

- Show quoted text -

Might be worth mentioning the custom format of [hh]:mm etc - this
would POTENTIALLY remove the need to change the time values

Converting hr min sec into numbers
 

Yes, just to use =A1 and format as [s] would give a number that would
display as 208626, but if (as the OP says), the purpose is to have a number
to use in further manipulation, this didn't seem the ideal route.
--
David Biddulph

wrote in message
ps.com...

Might be worth mentioning the custom format of [hh]:mm etc - this
would POTENTIALLY remove the need to change the time values

On 17 Aug, 13:10, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=A1*24*60*60 (or =A1*86400) and format the result as General or Number,
not
as Time.
--
David Biddulph

wrote in message

ps.com...



I am looking at invoices that have captured time spent on activity,
the system reports duration in hr min sec ( 5:47:06). I need to
convert this into a numbers that I can manipulate I could create a
formula such as = (5*3600) + (47*60) +06, however that is very manual
and I am looking at too many numbers. Is there something else I can
do? Thanks Shiftaw- Hide quoted text -

- Show quoted text -

Converting hr min sec into numbers
 

On Aug 17, 10:47 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Yes, just to use =A1 and format as [s] would give a number that would
display as 208626, but if (as the OP says), the purpose is to have a number
to use in further manipulation, this didn't seem the ideal route.
--
David Biddulph

wrote in message

ps.com...





Might be worth mentioning the custom format of [hh]:mm etc - this
would POTENTIALLY remove the need to change the time values
On 17 Aug, 13:10, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=A1*24*60*60 (or =A1*86400) and format the result as General or Number,
not
as Time.
--
David Biddulph

wrote in message

oups.com...

I am looking at invoices that have captured time spent on activity,
the system reports duration in hr min sec ( 5:47:06). I need to
convert this into a numbers that I can manipulate I could create a
formula such as = (5*3600) + (47*60) +06, however that is very manual
and I am looking at too many numbers. Is there something else I can
do? Thanks Shiftaw- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Thank you this was very helpful....