Calculated Fields - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> Calculated Fields

Reply

Search this Thread

#1 (permalink)

Old

07-24-11, 09:59

ridge1

ridge1 is offline

Registered User

Join Date: Jul 2011

Posts: 3

Calculated Fields

Hiya

I have these fields on my table "Jobs"

ArriveTime (Combo)
DepartTime (Combo)
BreakStart (Combo)
BreakEnd (Combo)

TotalTime

I need to add the Arrive & Depart Time - BreakTimes

So if they start work @ 8am
Finish work @@ 4pm

And start Lunch @ 12pm
End lunch : 12:30pm

This would be - 7.5 Hours

Cheers

Reply With Quote

#2 (permalink)

Old

07-24-11, 13:24

guelphdad

guelphdad is offline

Registered User

Join Date: Mar 2004

Posts: 440

so what have you tried so far?

Reply With Quote

#3 (permalink)

Old

07-24-11, 14:15

ridge1

ridge1 is offline

Registered User

Join Date: Jul 2011

Posts: 3

to be honest, not very much

I have googled it, and all I can really find is calculating Age and Dates but not so much time

Reply With Quote

#4 (permalink)

Old

07-25-11, 03:08

pasthana@netlink. pasthana@netlink. is offline

pasthana@netlink. is offline

Registered User

Join Date: Jul 2011

Location: India

Posts: 13

Hi,

MySQL :: Re: How to calculate time difference

hope it help

all the best

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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 Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules