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: 84
Default Convert time entered to decimal

I am trying to create a spreadsheet in which I can enter an actual time (1:13
pm) and have it convert it to a decimal. Tried excel help, to no avail.
Output of this is I want an employee to enter their start and end times each
day and have the sheet calculate the time spent at work. Thanks!
 
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 time into decimal Richard[_2_] New Users to Excel 4 March 25th 07 06:35 PM
convert time into decimal Richard[_2_] New Users to Excel 0 March 25th 07 04:15 PM
convert decimal to time ganga Excel Discussion (Misc queries) 3 March 2nd 07 11:14 PM
How to convert time to decimal frankie New Users to Excel 1 May 24th 06 04:44 PM
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM


All times are GMT +1. The time now is 08:39 PM.

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

About Us

"It's about Microsoft Excel"