LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Identifing total hours as a whole number

I have set up a little spreadsheet using "start time" and "end time". The
resulting difference is expressed in hours and minutes. I would like to use
this figure to calculate pay. It is not doing that because of the
formating. Is there a way?


 
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
total hours vs total worked hours tryingtolearn Excel Discussion (Misc queries) 1 November 19th 06 10:24 PM
How to seperate OT and Reg. Hours from total hours cmc1111 Excel Worksheet Functions 6 August 23rd 06 05:18 PM
adding total number of hours in excel? Ramy Excel Worksheet Functions 1 June 30th 06 10:07 PM
Convert Total Hours and Minutes to Whole Number BobS9895 Excel Worksheet Functions 3 April 13th 06 07:56 PM
how to convert total hours (HH:MM) into decimal number Greg T Excel Worksheet Functions 1 November 17th 04 03:07 PM


All times are GMT +1. The time now is 12:49 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"