Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I convert 8:30 to 8.5 hours?
I am trying to create a scheduler and need to find out the hours worked in a
given day. For example, I worked from 9:00 AM to 5:30 PM with an hour break. I would like to return a value of 8.5 hours minus 1 hour equals 7.5 hours. Thanks. |
#2
|
|||
|
|||
Multiply by 24 and format as either general or number (don't format as time)
to subtract an hour you can just subtract one =(end-start)*24-1 if your lunch can differ you set it up like =(D1-A1-(C1-B1))*24 where D1 is end, A1 start, B1 lunch out and C1 lunch in -- Regards, Peo Sjoblom (No private emails please) "Gene Mah" <Gene wrote in message ... I am trying to create a scheduler and need to find out the hours worked in a given day. For example, I worked from 9:00 AM to 5:30 PM with an hour break. I would like to return a value of 8.5 hours minus 1 hour equals 7.5 hours. Thanks. |
#3
|
|||
|
|||
The problem is I have at least 30 employees and it gets more complicated.
It's hard to explain, but I can send you the worksheet so I can explain it better. Thanks. "Peo Sjoblom" wrote: Multiply by 24 and format as either general or number (don't format as time) to subtract an hour you can just subtract one =(end-start)*24-1 if your lunch can differ you set it up like =(D1-A1-(C1-B1))*24 where D1 is end, A1 start, B1 lunch out and C1 lunch in -- Regards, Peo Sjoblom (No private emails please) "Gene Mah" <Gene wrote in message ... I am trying to create a scheduler and need to find out the hours worked in a given day. For example, I worked from 9:00 AM to 5:30 PM with an hour break. I would like to return a value of 8.5 hours minus 1 hour equals 7.5 hours. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert a number of minutes into hours and minutes? | Excel Worksheet Functions | |||
Convert a number of minutes like 400 into hours and minutes | Excel Worksheet Functions | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
How can I convert fractional hours to minutes? | Excel Discussion (Misc queries) | |||
convert hours and minutes to minutes | Excel Discussion (Misc queries) |