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....