Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timesheet - convert time format
Hi! I'm creating a time sheet to log daily hours worked - in order to get a
decent idea of what my Gross paycheck will be. Right now the formula I'm using to figure out my daily hours worked, is just a simple Time Out - Time In. The only problem is that this reports the Hours Worked in a Hour:Minute format. Ex. As shown below, my timesheet reports that if I work from 6:45 to 13:35, i will have worked 6hrs:50mins. I would like to modify the current formula so that it reads "6.83" hours (equal to 6hrs and 50 mins) in the Hours Worked column. If you know how to do this, please share! DATE | TIME IN | TIME OUT | HOURS WORKED 4/25 6:45 13:35 6:50 (C2-B2) Much Thanks, -Abby |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timesheet - convert time format
Multiply by 24:
=(C2-B2)*24 Format as GENERAL or NUMBER Using your sample times the result will be 6.83333333333333 You will probably want to round that to 2 decimal places: =ROUND((C2-B2)*24,2) Result is 6.83 -- Biff Microsoft Excel MVP "Abby" wrote in message ... Hi! I'm creating a time sheet to log daily hours worked - in order to get a decent idea of what my Gross paycheck will be. Right now the formula I'm using to figure out my daily hours worked, is just a simple Time Out - Time In. The only problem is that this reports the Hours Worked in a Hour:Minute format. Ex. As shown below, my timesheet reports that if I work from 6:45 to 13:35, i will have worked 6hrs:50mins. I would like to modify the current formula so that it reads "6.83" hours (equal to 6hrs and 50 mins) in the Hours Worked column. If you know how to do this, please share! DATE | TIME IN | TIME OUT | HOURS WORKED 4/25 6:45 13:35 6:50 (C2-B2) Much Thanks, -Abby |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timesheet - convert time format
=(C2-B2)*24
and format as General -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Abby" wrote in message ... Hi! I'm creating a time sheet to log daily hours worked - in order to get a decent idea of what my Gross paycheck will be. Right now the formula I'm using to figure out my daily hours worked, is just a simple Time Out - Time In. The only problem is that this reports the Hours Worked in a Hour:Minute format. Ex. As shown below, my timesheet reports that if I work from 6:45 to 13:35, i will have worked 6hrs:50mins. I would like to modify the current formula so that it reads "6.83" hours (equal to 6hrs and 50 mins) in the Hours Worked column. If you know how to do this, please share! DATE | TIME IN | TIME OUT | HOURS WORKED 4/25 6:45 13:35 6:50 (C2-B2) Much Thanks, -Abby |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timesheet - convert time format
Thanks guys, I figured it would be something extremely simple like that!!
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timesheet - convert time format
You're welcome!
-- Biff Microsoft Excel MVP "Abby" wrote in message ... Thanks guys, I figured it would be something extremely simple like that!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert into time format | New Users to Excel | |||
convert 7h 40.80n into time format | Excel Worksheet Functions | |||
Convert time format to a decimal | Excel Worksheet Functions | |||
how do I convert utc to a readable time format? | Excel Discussion (Misc queries) | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions |