Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date-to-number in Excel
Hi all,
I have a cell that is a "start time" and a cell that is an "end time" and a cell that is just the difference between the two. I have a fourth cell that contains an arbitrary number. Say, 22. ie: a b c d 13:00 13:40 0:40 22 The goal is to figure out what my rate per hour is. So I need to divide sixty minutes by the time span to arrive at 1.5, then multiply that by d (22) to get 33. So if I spent forty minutes doing something and I made 22 units, in an hour I would make 33. Simple, right? I CAN'T FIGURE OUT HOW TO DO IT IN EXCEL! I've tried changing the types, everything I can think of. Help? Thanks, Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert number to date in excel 2003 | Excel Discussion (Misc queries) | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
excel changes a number to a date and i don't want it to | Excel Discussion (Misc queries) | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
how to get the number of days between two date formatted fields in vba for excel? | Excel Worksheet Functions |