LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert into time format cognac New Users to Excel 2 November 11th 07 08:11 PM
convert 7h 40.80n into time format Todd Excel Worksheet Functions 1 August 9th 06 01:33 AM
Convert time format to a decimal Michele Excel Worksheet Functions 2 July 17th 06 07:54 PM
how do I convert utc to a readable time format? Jon Excel Discussion (Misc queries) 2 June 8th 06 02:40 PM
convert time imported as text to time format for calculations batfish Excel Worksheet Functions 3 October 27th 05 11:24 PM


All times are GMT +1. The time now is 11:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"