calculation between cells in different formats

[gizmo]

Hi guys,

I have two columns: the first one is the time worked by an employee
([h]:mm:ss --> f.ex. 170:05:00), the second is the salary paid (f.ex.
5500.00).
I would like to calculate the salary per hour, however, if I do just B2/A2,
it gives me 18626:09:49 (in [h]:mm:ss format), and changing format of the
cell to General or Number gives false figures.
Any idea how to calculate it automatically?

Thanks a lot!

Gizmo

 

[Frank Kabel]

Hi
try multiplying your time value with 24 (Excel stores 1 hour as 1/24)

 

[gizmo]

You are a wizard Frank! It works!
Thanks a lot!!

Gizmo

Hi
try multiplying your time value with 24 (Excel stores 1 hour as 1/24)

--
Regards
Frank Kabel
Frankfurt, Germany

Hi guys,

I have two columns: the first one is the time worked by an employee
([h]:mm:ss --> f.ex. 170:05:00), the second is the salary paid (f.ex.
5500.00).
I would like to calculate the salary per hour, however, if I do just
B2/A2, it gives me 18626:09:49 (in [h]:mm:ss format), and changing
format of the cell to General or Number gives false figures.
Any idea how to calculate it automatically?

Thanks a lot!

Gizmo

 

[Ragdyer]

Posting attachments in these groups is frowned upon and considered rude!
Please refrain from doing so in the future.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Hi Gizmo

It a bit long winded but I hope this helps, if anyone has a shorter way of
working this out please let me know

Mikey

Hi guys,

I have two columns: the first one is the time worked by an employee
([h]:mm:ss --> f.ex. 170:05:00), the second is the salary paid (f.ex.
5500.00).
I would like to calculate the salary per hour, however, if I do just B2/A2,
it gives me 18626:09:49 (in [h]:mm:ss format), and changing format of the
cell to General or Number gives false figures.
Any idea how to calculate it automatically?

Thanks a lot!

Gizmo

 

[Peo Sjoblom]

Can you please stop posting attachments to a non binary newsgroup?

http://www.cpearson.com/excel/Attachments.htm

I give you benefits of a doubt if you are new to this

http://www.cpearson.com/excel/newposte.htm


--
Thanks,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Hi Gizmo

It a bit long winded but I hope this helps, if anyone has a shorter way of
working this out please let me know

Mikey

Hi guys,

I have two columns: the first one is the time worked by an employee
([h]:mm:ss --> f.ex. 170:05:00), the second is the salary paid (f.ex.
5500.00).
I would like to calculate the salary per hour, however, if I do just B2/A2,
it gives me 18626:09:49 (in [h]:mm:ss format), and changing format of the
cell to General or Number gives false figures.
Any idea how to calculate it automatically?

Thanks a lot!

Gizmo

 

[Gord Dibben]

Mikey

FYI. Attachments are frowned upon in these Excel news groups.

Viruses, band-width wastage etc.

Please use private email to send attachments to posters who have specifically
requested them.

The rest of us can get by on textual descriptions of problems and possible
solutions.

Thanks, Gord Dibben Excel MVP

Hi Gizmo

It a bit long winded but I hope this helps, if anyone has a shorter way of
working this out please let me know

Mikey

Hi guys,

I have two columns: the first one is the time worked by an employee
([h]:mm:ss --> f.ex. 170:05:00), the second is the salary paid (f.ex.
5500.00).
I would like to calculate the salary per hour, however, if I do just B2/A2,
it gives me 18626:09:49 (in [h]:mm:ss format), and changing format of the
cell to General or Number gives false figures.
Any idea how to calculate it automatically?

Thanks a lot!

Gizmo