PC Review


Reply
Thread Tools Rate Thread

How to Calculate no. of hours in a stipulated time?

 
 
=?Utf-8?B?TVVSVUdBTkdFTklVUw==?=
Guest
Posts: n/a
 
      22nd Jun 2007
for example if a employee logs in at 5.00pm in the evening and logs out at
3.30am, how to calculate the no.of hours between 5.00pm and 3.30am, (date is
not captured)
 
Reply With Quote
 
 
 
 
=?Utf-8?B?TWlrZSBI?=
Guest
Posts: n/a
 
      22nd Jun 2007
Try,

Start time in A1, end time in B1

=(B1-A1+(B1<A1))*24

Mike

"MURUGANGENIUS" wrote:

> for example if a employee logs in at 5.00pm in the evening and logs out at
> 3.30am, how to calculate the no.of hours between 5.00pm and 3.30am, (date is
> not captured)

 
Reply With Quote
 
=?Utf-8?B?VG9wcGVycw==?=
Guest
Posts: n/a
 
      22nd Jun 2007
A1=17:00
B1=03:30
in C1, format as General:

=MOD(B1-A1,1)*24

Number of hours as decimal number

HTH

"MURUGANGENIUS" wrote:

> for example if a employee logs in at 5.00pm in the evening and logs out at
> 3.30am, how to calculate the no.of hours between 5.00pm and 3.30am, (date is
> not captured)

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I calculate time - Hours and Minutes Gunther Dawson Microsoft Access 6 21st Oct 2008 11:55 AM
RE: Calculate the travel time hours Duane Hookom Microsoft Access Queries 0 1st Apr 2008 06:01 AM
Calculate negative hours (time) Jolanta Microsoft Excel Worksheet Functions 7 18th Sep 2007 12:28 PM
calculate hours using start time & end time, excluding weekends noname Microsoft Excel Programming 7 13th Apr 2007 10:15 AM
calculate difference in time to hours =?Utf-8?B?Q2hyaXM=?= Microsoft Excel Worksheet Functions 4 18th Jan 2005 06:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:37 PM.