Excel works just like Access - the format you define for the Cell determines how the value is displayed, so you should be able to display 12-hour times. To calculate the total time (in fractions of an hour), do this:
=([end] - [Start]) * 24 Frankly, fractions of an hour make more sense to me. But if you want hours and minutes, simply subtract the two values and set the format of the Cell to hour and minutes. To calculate the charge, you need to use the IF Excel function: =IF(([End] - [Start]) * 24 * 5 > 3, ([End] - [Start]) *24 * 5, 3) John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ P.S. Why not post Excel questions in an Excel group? -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of ba_latheef Sent: Thursday, December 01, 2005 8:57 AM To: [email protected] Subject: [ms_access] Computer time calculator PLEASE HELP... Dear friends, i wishing you all the best i want a calculator in my Internet Cafe which Ending time - Starting time = Total used time and cost minimum 3.00$, per hour 5.00$, i have sent a sample MS Excel file, but i want Standared time formate (12 hours) and client computer locking also. please help me Eg:- Client Start End Total Time Total Amount ------ -------- -------- ---------- ------------ User 1 10.00 AM 12.00 AM 02.00 10.00$ User 2 10.00 AM 10.30 AM 00.30 03.00$ User 3 10.00 AM 02.00 PM 04.00 20.00$ User 4 02.00 PM 03.30 PM 01.30 07.50$ Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/2jUsvC/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
